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