Dump all objects under a specific schema

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 Wed, 8 Aug 2007, Emi Lu wrote:

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

This questions has nothing to do with Java or JDBC, so cross posting it to
this list is inappropriate. Please only send Java related questions here.

Kris Jurka

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