| From: | davidh <david(at)beechglen(dot)com> |
|---|---|
| To: | Piyush Lenka <lenka(dot)piyush(at)gmail(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Restoring selected records from backup file |
| Date: | 2012-03-03 14:17:02 |
| Message-ID: | 5E065B94-763E-4CEF-B235-6E6632CDF35C@beechglen.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
The only way I know of doing this is to restore the backup to a separate database or table and doing a "SELECT INTO" statement. The only caveat is that you need to make sure you delete the outdated records from the prod table. To do this you may have to temporarily disable foreign key enforcing.
David.
On Mar 2, 2012, at 5:19 AM, Piyush Lenka <lenka(dot)piyush(at)gmail(dot)com> wrote:
> hi,
>
> 1. How can we restore selected records from a plain text backup (backup.sql).
> 2. Is it possible using psql. If yes how
> Please Help
>
> Thanks & Regards
> Piyush
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2012-03-03 18:27:19 | Re: re-create information_schema |
| Previous Message | Piyush Lenka | 2012-03-02 10:19:30 | Restoring selected records from backup file |