| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | zhangtingting <zhangtingting(at)xiaohongchun(dot)com> |
| Cc: | pgsql-bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: please help me |
| Date: | 2016-05-23 15:17:09 |
| Message-ID: | CAKFQuwaO7==pCpoSWqNpeLbqTdvtFo5PJ8=1w_mnrm49JZcejg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Mon, May 23, 2016 at 4:52 AM, zhangtingting <
zhangtingting(at)xiaohongchun(dot)com> wrote:
> hi:
>
> i have e question for postgres,when i restore backup from pg_dump ,psql
> can’t change anather table
>
I'm losing something in the translation...what you posed isn't a question
for one.
While you can choose to only restore portions of an pg_dump archive if you
choose to restore an object you restore the entire object as it was at the
time it was dumped.
You can choose not to restore an object at all, restore only its
definition, restore only its data (all of its data), or restore both object
definition and data.
This is using pg_restore.
You can manually edit an SQL dump file if you so choose but that is on you
to accomplish correctly.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2016-05-23 15:31:17 | Re: BUG #14154: In pgpool while using delete query inside postgresql function , it is not deletingdata from all serve |
| Previous Message | priyeshkaratha | 2016-05-23 13:29:38 | BUG #14154: In pgpool while using delete query inside postgresql function , it is not deletingdata from all serve |