| From: | Phil Endecott <spam_from_postgresql_general(at)chezphil(dot)org> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_restore -l and schema name |
| Date: | 2004-10-08 14:07:27 |
| Message-ID: | 41669F1F.8080909@chezphil.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dear Postgresql people,
For the first time I'm trying to use pg_restore to do a partial restore.
It looks as if it should be easy: pg_restore -l, filter out the
required tables, then pg_restore -L. But unfortunately the listing
generated by pg_resotre doesn't include the schema name! Since my
database consists of lots of almost-identical schemas, I'm a bit stuck.
So this message is really a feature request for "please include the
schema name in the pg_restore -l output". Also, I'd be interested to
hear from anyone who has faced this problem before and can suggest how
to work around it.
Thanks in advance for any help.
Regards,
--Phil.
p.s. I'm logging long-running statements to syslog, and I'd also love to
see schema names there. But that's a less important problem.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-10-08 14:11:36 | Re: query gone haywire :) |
| Previous Message | Tom Lane | 2004-10-08 13:52:00 | Re: Question about timezones |