Обсуждение: Dump all objects under a specific schema

Hello List,

Is there a way that I can only dump all objects under a specific schema?

I'd like to dump all tables, views' definition and data under a specific
schema.


Thank you!

Hi;
> Hello List,
>
> Is there a way that I can only dump all objects under a specific
> schema?
>
> I'd like to dump all tables, views' definition and data under a
> specific schema.
>
pg_dump --help says that you're looking for the -n flag, so,

pg_dump -n <your_schema> -f output.sql

Hope that helps,

Aurynn Shaw

The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 ext 103
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

ashaw@commandprompt.com

On Aug 8, 2007, at 14:18 , Emi Lu wrote:

> Is there a way that I can only dump all objects under a specific
> schema?

Have you checked the pg_dump documentation?

http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html

In particular, the -n flag might interest you.

Michael Glaesemann
grzm seespotcode net