On Thu, Aug 7, 2008 at 4:34 PM, Brian Maguire <bmaguire@xxxxxxxxxxx> wrote: > 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. You have read this page, right: http://www.postgresql.org/docs/8.1/interactive/app-pgrestore.html