How do I restore just a table to a database? I was able to create a backup of the required table from a backup of the database as follows.
I don’t know how to properly restore the backed up table “departments” to the original “sms” database.
create a new db
createdb -U postgres smstest
restore a backup of the db to the new db
psql -U postgres smstest < /tmp/postgresql-sms-11-24-2008_04-05-database
backup up the specific table from the restored db
pg_dump -U postgres -a -t departments smstest > /tmp/smsdepartments
The table backup is smsdepartments. How do I restore smsdepartments to the table called departments in the sms database?
Thanks
Marc