| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Blair Lowe <postgresql(at)zedemail(dot)ca> |
| Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dump and grants to PUBLIC |
| Date: | 2006-05-12 17:03:48 |
| Message-ID: | 4464BFF4.2020702@commandprompt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> Thanks Joshua,
>
> According to the man page:
> -s
> --schema-only
> Dump only the schema (data definitions), no data.
>
> I need data too.
>
> What are the command line options to get a user's schema, and a user's data?
You are confusing "The Schema" with "Schemas". It is a common mistake:
-n, --schema=SCHEMA dump the named schema only
Joshua D. Drake
>
> Thanks,
> Blair
>
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2006-05-12 17:08:04 | Re: pg_dump and grants to PUBLIC |
| Previous Message | Tony Caduto | 2006-05-12 17:02:13 | Re: GUI Interface |