Thanks Rajesh. Is this on TODO list? I think it's beneficial to be able to backup (or oracle term, export) several tables (NOT only ONE) and restore (import) back to another database for instance from a production DB to a development or staging to prod, etc..) [This is doable in Oracle too via the export/import utilities.] -- Husam -----Original Message----- From: Rajesh Kumar Mallah [mailto:mallah.rajesh@xxxxxxxxx] Sent: Thursday, September 22, 2005 1:16 PM To: Tomeh, Husam Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Backing up several tables using pg_dump -t man pg_dump seems to say it is not possible -t table --table=table Dump data for table only. It is possible for there to be multi- ple tables with the same name in different schemas; if that is the case, all matching tables will be dumped. Specify both --schema and --table to select just one table. Note: In this mode, pg_dump makes no attempt to dump any other database objects that the selected table may depend upon. There- fore, there is no guarantee that the results of a single-table dump can be successfully restored by themselves into a clean database. On 9/23/05, Tomeh, Husam <htomeh@xxxxxxxxxxx> wrote: > > 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 > ********************************************************************** > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
