Re: [GENERAL] dump schema schema only?
Tom Lane wrote: Harald Fuchs [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: 7.4's pg_dump has an option to dump the contents of just one schema. The pg_dump manpage of beta4 does not include this option, Sure it does: -n namespace --schema=schema Dump the contents of schema only. If this option is not specified, all non-system schemas in the target database will be dumped. I thought he was complaining because our 'man' output wasn't updated for 7.4. I just checked beta5's man.tar.gz, and it has the 7.3 contents, and doesn't mention -n/--schema. I have added to our open items list: Update manual pages. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [GENERAL] dump schema schema only?
Harald Fuchs [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: 7.4's pg_dump has an option to dump the contents of just one schema. The pg_dump manpage of beta4 does not include this option, Sure it does: -n namespace --schema=schema Dump the contents of schema only. If this option is not specified, all non-system schemas in the target database will be dumped. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [GENERAL] dump schema schema only?
Patrick Hatcher [EMAIL PROTECTED] writes: I have a development server where I, well, do my development. Occasionally, I will create a new schema within an existing database that I would like to use on my production machine. I know that doing a pg_dump -s database somefile.sql will dump the entire schema of the database, but is there a way to export only schema X from the database? 7.4's pg_dump has an option to dump the contents of just one schema. regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [GENERAL] dump schema schema only?
You can use -t to specify a table: % pg_dump -s database -t tablename -Rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Patrick Hatcher Sent: Wednesday, October 29, 2003 12:57 PM To: [EMAIL PROTECTED] Subject: [GENERAL] dump schema schema only? I have a development server where I, well, do my development. Occasionally, I will create a new schema within an existing database that I would like to use on my production machine. I know that doing a pg_dump -s database somefile.sql will dump the entire schema of the database, but is there a way to export only schema X from the database? TIA Patrick Hatcher ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 8: explain analyze is your friend
