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.
HTH
Shridhar