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.




---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to