Re: [GENERAL] pg_restore - selective restore use cases. HINT use DROP CASCADE

2014-01-10 Thread Day, David
assistance. Dave -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Thursday, January 09, 2014 6:09 PM To: Day, David; pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_restore - selective restore use cases. HINT use DROP CASCADE On 01/09/2014 01:51 PM,

Re: [GENERAL] pg_restore - selective restore use cases. HINT use DROP CASCADE

2014-01-09 Thread Adrian Klaver
On 01/09/2014 01:51 PM, Day, David wrote: Adrian, Thank you for your response. I would note that the original dump archive created by pg_dump included all schemas and that I only intend to restore a schema from it that is self contained, or a group of related tables from it. I just tried th

Re: [GENERAL] pg_restore - selective restore use cases. HINT use DROP CASCADE

2014-01-09 Thread Day, David
ke to own the firearm :+) Regards Dave Day -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Thursday, January 09, 2014 3:47 PM To: Day, David; pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_restore - selective restore use cases. HINT use DROP CA

Re: [GENERAL] pg_restore - selective restore use cases. HINT use DROP CASCADE

2014-01-09 Thread Adrian Klaver
On 01/09/2014 08:51 AM, Day, David wrote: I have needs to do selective schema or table restorations and the pg_restore utility seems to have hooks for this, yet seems deficient for this type of problem. It appears that I have to develop a custom script to do what I think would be a standard ki