The following command spits out a sql file.
pg_dump -h localhost -U myuser -d -t mytable mydb > mydb.sql
The following command restores from sql file
psql -h localhost -U myuser -f mydb.sql
Category: Tech Articles