pg_restore -l and schema name - Mailing list pgsql-general

From Phil Endecott
Subject pg_restore -l and schema name
Date
Msg-id 41669F1F.8080909@chezphil.org
Whole thread Raw
Responses Re: pg_restore -l and schema name  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question about timezones
Next
From: Tom Lane
Date:
Subject: Re: query gone haywire :)