[SQL] pgdump by schema?

[Bradley Miller]

--Apple-Mail-9-202183516
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
format=flowed

Is there a way to dump everything in a particular schema?

Bradley Miller
NUVIO CORPORATION
Phone: 816-444-4422 ext. 6757
Fax: 913-498-1810
http://www.nuvio.com
bmi...@nuvio.com

--Apple-Mail-9-202183516
Content-Transfer-Encoding: 7bit
Content-Type: text/enriched;
charset=US-ASCII

Is there a way to dump everything in a particular schema?

Bradley Miller

<bold><fontfamily><param>Arial</param><color><param>1313,0000,FFFF</param><x-tad-bigger>NUVIO
CORPORATION</x-tad-bigger></color></fontfamily></bold><fontfamily><param>Arial</param><x-tad-bigger>

Phone: 816-444-4422 ext. 6757

Fax: 913-498-1810

</x-tad-bigger><color><param>0000,0000,FFFF</param><x-tad-bigger>http://www.nuvio.com</x-tad-bigger></color><x-tad-bigger>

</x-tad-bigger><color><param>0000,0000,FFFF</param><x-tad-bigger>bmi...@nuvio.com</x-tad-bigger></color></fontfamily>

--Apple-Mail-9-202183516--

[Kretschmer Andreas]

am Wed, dem 02.02.2005, um 9:33:22 -0600 mailte Bradley Miller folgendes:

> Is there a way to dump everything in a particular schema?

RTFM.

man pg_dump, search for --schema

Regards, Andreas
--
Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau-
fenden Pinguins aus artgerechter Freilandhaltung. Er ist garantiert frei
von Micro$oft'schen Viren. (#97922 http://counter.li.org) GPG 7F4584DA
Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majo...@postgresql.org

[Adam Witney]

From: pg_dump --help

-n, --schema=SCHEMA dump the named schema only

> Is there a way to dump everything in a particular schema?
>
>

> Bradley Miller
> NUVIO CORPORATION
> Phone: 816-444-4422 ext. 6757
> Fax: 913-498-1810
> http://www.nuvio.com
> bmi...@nuvio.com

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Michael Fuhr]

On Wed, Feb 02, 2005 at 09:33:22AM -0600, Bradley Miller wrote:

> Is there a way to dump everything in a particular schema?

See the documentation for pg_dump. In PostgreSQL 7.4 and later,
pg_dump has a --schema (-n) option.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

[Bradley Miller]

--Apple-Mail-10-203691053

Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
charset=US-ASCII;
format=flowed

Thanks -- I was looking at a book and it didn't mention the schema dump
. . . should have done the man or --help before asking.

On Feb 2, 2005, at 9:46 AM, Adam Witney wrote:

>
> From: pg_dump --help
>
> -n, --schema=SCHEMA dump the named schema only
>

Bradley Miller

NUVIO CORPORATION
Phone: 816-444-4422 ext. 6757
Fax: 913-498-1810
http://www.nuvio.com
bmi...@nuvio.com

--Apple-Mail-10-203691053

Content-Transfer-Encoding: 7bit
Content-Type: text/enriched;
charset=US-ASCII

Thanks -- I was looking at a book and it didn't mention the schema
dump . . . should have done the man or --help before asking.

On Feb 2, 2005, at 9:46 AM, Adam Witney wrote:

<excerpt>

From: pg_dump --help

-n, --schema=SCHEMA dump the named schema only

</excerpt>

Bradley Miller

<bold><fontfamily><param>Arial</param><color><param>1313,0000,FFFF</param><x-tad-bigger>NUVIO
CORPORATION</x-tad-bigger></color></fontfamily></bold><fontfamily><param>Arial</param><x-tad-bigger>

Phone: 816-444-4422 ext. 6757

Fax: 913-498-1810

</x-tad-bigger><color><param>0000,0000,FFFF</param><x-tad-bigger>http://www.nuvio.com</x-tad-bigger></color><x-tad-bigger>

</x-tad-bigger><color><param>0000,0000,FFFF</param><x-tad-bigger>bmi...@nuvio.com</x-tad-bigger></color></fontfamily>

--Apple-Mail-10-203691053--