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