Skip site navigation (1) Skip section navigation (2)

Re: Dump all objects under a specific schema

From: Aurynn Shaw <ashaw(at)commandprompt(dot)com>
To: emilu(at)encs(dot)concordia(dot)ca
Cc: pgsql-jdbc(at)postgresql(dot)org, pgsql general list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Dump all objects under a specific schema
Date: 2007-08-08 20:20:29
Message-ID: C79357D3-5173-4D4C-98EF-F5B2A2D68390@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-jdbc
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(at)commandprompt(dot)com



In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2007-08-08 20:21:18
Subject: Re: Dump all objects under a specific schema
Previous:From: Emi LuDate: 2007-08-08 19:18:16
Subject: Dump all objects under a specific schema

pgsql-general by date

Next:From: novnovDate: 2007-08-08 20:20:33
Subject: Trigger not working as expected, first row gets a null value
Previous:From: clusterDate: 2007-08-08 20:06:33
Subject: Re: tsearch2: plainto_tsquery() with OR?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group