Re: [GENERAL] Cannot restore table using pg_restore

2008-11-25 Thread Tom Lane
Bill Todd <[EMAIL PROTECTED]> writes: > I am trying to restore a table named contact in the contact schema. I > have tried two methods. The first is the command > pg_restore --dbname=app --format=custom --schema=contact > --table=contact.contact --username=postgres --single-transaction > contac

[GENERAL] Cannot restore table using pg_restore

2008-11-25 Thread Bill Todd
I am new to PostgreSQL and am running 8.3.3 on Windows XP Pro SP3. I have dumped a database using the following command. pg_dump --format=custom --username=postgres --file=c:\pgdb\dumps\app.backup app I am trying to restore a table named contact in the contact schema. I have tried two metho