Horton

Re: DDL for a single schema

Richard Huxton <dev@archonet.com>

View thread View on postgr.es
From: Richard Huxton <dev@archonet.com>
To: <btober@seaworthysys.com>, <shridhar_daithankar@myrealbox.com>
Cc: <pgsql-general@postgresql.org>
Date: 2003-11-07T17:03:14Z
Lists: pgsql-general 
On Friday 07 November 2003 14:28, btober@seaworthysys.com wrote:
> > On Friday 07 November 2003 19:36, Shridhar Daithankar wrote:
> >> On Friday 07 November 2003 18:53, 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?
> >> pg_dump in 7.4 has the dump option. You need to use --schema as
> >> option.

> Thanks. Didn't have immediate plans to upgrade from 7.3. But I'll look
> for that feature when the time comes.

I believe 7.4 pg_dump should work against a 7.3 database (and further back 
IIRC).
-- 
  Richard Huxton
  Archonet Ltd