Horton

Re: DDL for a single schema

Rod Taylor <rbt@rbt.ca>

View thread View on postgr.es
From: Rod Taylor <rbt@rbt.ca>
To: btober@seaworthysys.com
Cc: pgsql-general@postgresql.org
Date: 2003-11-07T13:58:07Z
Lists: pgsql-general 
On Fri, 2003-11-07 at 08:23, btober@seaworthysys.com wrote:
> Is there a way to get a dump of all the DDL and data associated with a
> single schema within a database?

The 7.4 pg_dump is capable of this task (--schema=SCHEMA) but you may
have difficulties restoring to a 7.3 backend.