Converting Copy to insert statement in backup file - Mailing list pgsql-sql

From Chris Preston
Subject Converting Copy to insert statement in backup file
Date
Msg-id 200807101540.m6AFeA3T025524@mail2.trafalgar.lan
Whole thread Raw
Responses Re: Converting Copy to insert statement in backup file
List pgsql-sql

Hello,

I have a backup cron job (shown below) but its too big and there are times that I want to just cut out from the text file certain areas to restore data in a specific table… Looking in the file, I notice there is a “copy” command.. Someone told me that there was  a parameter that I could use to convert the copy to insert so I could easily cut it out of the file and run it on its own ..Any ideas

 

su -c '/usr/bin/pg_dump -U postgres -o -C ttms |gzip > /home/hrd/ttmsqltrams/sqlbackup.gz' postgres

pgsql-sql by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: i can't connect after some periode
Next
From: "Scott Marlowe"
Date:
Subject: Re: Converting Copy to insert statement in backup file