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