Re: Dump all objects under a specific schema

[Aurynn Shaw <ashaw@xxxxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxxxxx



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match