Re: pg_dump and schema namespace notes

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rory Campbell-Lange <rory(at)campbell-lange(dot)net>
Cc: Postgresql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump and schema namespace notes
Date: 2004-06-10 02:39:32
Message-ID: 200406100239.i5A2dWJ27479@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches


Any comments on this? It seems like a valid confusion. What solutions
are there?

---------------------------------------------------------------------------

Rory Campbell-Lange wrote:
> I think this is a suggestion/comment!
>
> pg_dump man page:
>
> --schema-only
> Dump only the schema (data definitions), no data
>
> I think this use of the word schema is confusing, meaning data
> definitions, whereas elsewhere in the man page schema are used as a
> namespace definition.
>
> --schema=schema
> Dump the contents of schema only. If this option is not
> speci- fied, all non-system schemas in the target
> database will be dumped
>
> It would be nice if this could be a comman separated list (like set
> search_path; A,info,public etc).
>
> Rory
> --
> Rory Campbell-Lange
> <rory(at)campbell-lange(dot)net>
> <www.campbell-lange.net>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2004-06-10 02:54:25 Re: pg_dump and schema namespace notes
Previous Message Bruce Momjian 2004-06-10 02:34:45 Re: Solaris ecpg program doesn't work - pulling my hair

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-06-10 02:42:43 Re: Re : Win32 binaries test / pg_dump problem
Previous Message Bruce Momjian 2004-06-10 02:36:33 Re: Tablespaces