Re: [GENERAL] dump schema schema only?

2003-10-30 Thread Bruce Momjian
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

Re: [GENERAL] dump schema schema only?

2003-10-30 Thread Tom Lane
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

Re: [GENERAL] dump schema schema only?

2003-10-29 Thread Tom Lane
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

Re: [GENERAL] dump schema schema only?

2003-10-29 Thread Rick Seeger
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