Re: DDL for a single schema

On Friday 07 November 2003 19:36, Shridhar Daithankar wrote:
> On Friday 07 November 2003 18:53, btober(at)seaworthysys(dot)com wrote:
> > Is there a way to get a dump of all the DDL and data associated with a
> > single schema within a database?
> >
> > What I tried in attempting to hack this out was
> >
> > \dt consume.*
> >
> > and
> >
> > \dv consume.*
> >
> > to get a list of tables and views in the schema named "consume", then
> > sent those lists to a file "tables.txt". Followed that with something
> > like
> >
> > for n in `cat tables.txt` do; pg_dump -t $n >> consume.sql; done
>
> pg_dump in 7.4 has the dump option. You need to use --schema as option.
>
> Check developers documentation on web site or download RC1 and try out
> yourself.

http://developer.postgresql.org/docs/postgres/app-pgdump.html

Sorry for missing it first time..

Shridhar