backup and restore with postgres

# dump to sql
$ pg_dump -h localhost -d postgres --username postgres -t '"Orders"" > public_orders.sql

# restore from sql
$ psql -h localhost -U postgres -d postgres < public_orders.sql

$ pg_restore -U postgres -d postgres -1 public_orders.sql