Backing up several tables using pg_dump -t

From: "Tomeh, Husam" <htomeh(at)firstam(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Backing up several tables using pg_dump -t
Date: 2005-09-22 19:38:07
Message-ID: C45835824D00A844BBD0F032D5CDED920116DD4F@pisgana01sxch01.ana.firstamdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


I'm having problem backing up several tables using pg_dump. When
selecting one table only with the '-t' option, it works just fine. When
I tried to include several tables, pg_dump fails with error that the
tables specified don't exist. Can you show me an example of backing up
several tables using pg_dump.

Thanks in advance,

--
Husam

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

**********************************************************************
This message contains confidential information intended only for the
use of the addressee(s) named above and may contain information that
is legally privileged. If you are not the addressee, or the person
responsible for delivering it to the addressee, you are hereby
notified that reading, disseminating, distributing or copying this
message is strictly prohibited. If you have received this message by
mistake, please immediately notify us by replying to the message and
delete the original message immediately thereafter.

Thank you. FADLD Tag
**********************************************************************

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2005-09-22 20:15:58 Re: Backing up several tables using pg_dump -t
Previous Message Tomeh, Husam 2005-09-22 19:32:50 COPY command and skipping errors