Postgres Pro
Downloads
Home   >   mailing lists

Thread: backup by schema

backup by schema

From
Frank Bax
Date:
I can find commands to dump one table or entire database; but is there an
easy way to dump all tables in one schema?  I'm current using 7.3.5 and 7.4.3

Re: backup by schema

From
"A. Kretschmer"
Date:
am  01.01.2006, um 10:00:52 -0500 mailte Frank Bax folgendes:
> I can find commands to dump one table or entire database; but is there an
> easy way to dump all tables in one schema?  I'm current using 7.3.5 and
> 7.4.3

Not sure with this old versions ;-), but pg_dump has a option '-n
schema' to dump the contents of schema only.


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

Re: backup by schema

From
Frank Bax
Date:
At 10:12 AM 1/1/06, A. Kretschmer wrote:

>am  01.01.2006, um 10:00:52 -0500 mailte Frank Bax folgendes:
> > I can find commands to dump one table or entire database; but is there an
> > easy way to dump all tables in one schema?  I'm current using 7.3.5 and
> > 7.4.3
>
>Not sure with this old versions ;-), but pg_dump has a option '-n
>schema' to dump the contents of schema only.


It's there in 7.4.3 - must have missed it yesterday.  Thanks.