Re: 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  -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