Skip site navigation (1) Skip section navigation (2)

dump schema schema only?

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: dump schema schema only?
Date: 2003-10-29 17:56:55
Message-ID: OFE1FDD382.2FA47317-ON88256DCE.00608CB9-88256DCE.00633F92@fds.com (view raw or flat)
Thread:
Lists: pgsql-general
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



Responses

pgsql-general by date

Next:From: Ron JrDate: 2003-10-29 18:30:28
Subject: Re: backup another server
Previous:From: scott.marloweDate: 2003-10-29 17:49:34
Subject: Re: backup another server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group