Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump and ON DELETE CASCADE problem - Mailing list pgsql-general

From John R Pierce
Subject Re: pg_dump and ON DELETE CASCADE problem
Date
Msg-id 4B215A2D.10505@hogranch.com
Whole thread Raw
In response to Re: pg_dump and ON DELETE CASCADE problem  (CG <cgg007@yahoo.com>)
Responses Re: pg_dump and ON DELETE CASCADE problem  (CG <cgg007@yahoo.com>)
List pgsql-general
Tree view 
CG wrote:
> Thanks for the suggestion. I'm not sure what you mean when you say I should restore to a file. Do you mean I should
dumpthe database to an SQL file instead of the "compressed" format? 
>

he meant...

    pg_restore -f outputfile.sql yourdumpfile

this will convert the dumpfile to SQL...

pgsql-general by date:

Previous
From: CG
Date:
Subject: Re: pg_dump and ON DELETE CASCADE problem
Next
From: Adrian Klaver
Date:
Subject: Re: pg_dump and ON DELETE CASCADE problem