| From: | Blair Lowe <postgresql(at)zedemail(dot)ca> |
|---|---|
| To: | aklaver(at)comcast(dot)net |
| Cc: | pgsql-general(at)postgresql(dot)org, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: pg_dump and grants to PUBLIC |
| Date: | 2006-05-12 17:16:04 |
| Message-ID: | 1147454165.4575.41.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2006-12-05 at 10:08 -0700, Adrian Klaver wrote:
> On Friday 12 May 2006 09:50 am, Blair Lowe wrote:
> See following-
> -n schema
> --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.
>
> Note: In this mode, pg_dump makes no attempt to dump any other
> database objects that objects in the selected schema may depend upon.
> Therefore, there is no guarantee that the results of a single-schema dump can
> be successfully restored by themselves into a clean database.
In postgreSQL version 7.3.4:
user# pg_dump -n <schema_name> > tmp95.sql
pg_dump: invalid option -- n
Try 'pg_dump --help' for more information.
phpbb only works with version 7.x.
TTYL,
Blair.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2006-05-12 17:34:09 | Re: GUI Interface |
| Previous Message | Joshua D. Drake | 2006-05-12 17:08:12 | Re: GUI Interface |