We need to restore one table from a backup. What is the proper way to do this?
Our backup command looks like this:
pg_dump -C -Fc -S postgresql mydatabase > today.backup.sqlc
I am using PostgreSQL 8.1.