Обсуждение: dump schema schema only?
I have a development server where I, well, do my development. Occasionally, I will create a new schema within an existing database that I would like to use on my production machine. I know that doing a pg_dump -s <database> > somefile.sql will dump the entire schema of the database, but is there a way to export only schema X from the database? TIA Patrick Hatcher
You can use -t to specify a table:
% pg_dump -s database -t tablename
-Rick
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Patrick
Hatcher
Sent: Wednesday, October 29, 2003 12:57 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] dump schema schema only?
I have a development server where I, well, do my development.
Occasionally,
I will create a new schema within an existing database that I would
like to
use on my production machine. I know that doing a pg_dump -s
<database>
> somefile.sql will dump the entire schema of the database, but is
there a
way to export only schema X from the database?
TIA
Patrick Hatcher
---------------------------(end of
broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)
"Patrick Hatcher" <PHatcher@macys.com> writes:
> I have a development server where I, well, do my development. Occasionally,
> I will create a new schema within an existing database that I would like to
> use on my production machine. I know that doing a pg_dump -s <database>
> > somefile.sql will dump the entire schema of the database, but is there a
> way to export only schema X from the database?
7.4's pg_dump has an option to dump the contents of just one schema.
regards, tom lane
In article <20051.1067459901@sss.pgh.pa.us>, Tom Lane <tgl@sss.pgh.pa.us> writes: > "Patrick Hatcher" <PHatcher@macys.com> writes: >> I have a development server where I, well, do my development. Occasionally, >> I will create a new schema within an existing database that I would like to >> use on my production machine. I know that doing a pg_dump -s <database> >> > somefile.sql will dump the entire schema of the database, but is there a >> way to export only schema X from the database? > 7.4's pg_dump has an option to dump the contents of just one schema. The pg_dump manpage of beta4 does not include this option, although the source code does. Has this been fixed in beta5?
Harald Fuchs <nospam@sap.com> writes:
> Tom Lane <tgl@sss.pgh.pa.us> writes:
>> 7.4's pg_dump has an option to dump the contents of just one schema.
> The pg_dump manpage of beta4 does not include this option,
Sure it does:
-n namespace
--schema=schema
Dump the contents of schema only. If this option is not specified,
all non-system schemas in the target database will be dumped.
regards, tom lane
Harald Fuchs wrote: > In article <20051.1067459901@sss.pgh.pa.us>, > Tom Lane <tgl@sss.pgh.pa.us> writes: > > > "Patrick Hatcher" <PHatcher@macys.com> writes: > >> I have a development server where I, well, do my development. Occasionally, > >> I will create a new schema within an existing database that I would like to > >> use on my production machine. I know that doing a pg_dump -s <database> > >> > somefile.sql will dump the entire schema of the database, but is there a > >> way to export only schema X from the database? > > > 7.4's pg_dump has an option to dump the contents of just one schema. > > The pg_dump manpage of beta4 does not include this option, although > the source code does. Has this been fixed in beta5? Really? Perhaps we haven't updated the manual pages, but the SGML is OK. I have added this to the list to be done before 7.4 final. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Tom Lane wrote:
> Harald Fuchs <nospam@sap.com> writes:
> > Tom Lane <tgl@sss.pgh.pa.us> writes:
> >> 7.4's pg_dump has an option to dump the contents of just one schema.
>
> > The pg_dump manpage of beta4 does not include this option,
>
> Sure it does:
>
> -n namespace
> --schema=schema
>
> Dump the contents of schema only. If this option is not specified,
> all non-system schemas in the target database will be dumped.
I thought he was complaining because our 'man' output wasn't updated for
7.4. I just checked beta5's man.tar.gz, and it has the 7.3 contents,
and doesn't mention -n/--schema. I have added to our open items list:
Update manual pages.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073