Re: please help me

On Mon, May 23, 2016 at 4:52 AM, zhangtingting <
zhangtingting@xiaohongchun.com> wrote:

> hi:
>
> i have e question for postgres,when i restore backup from pg_dump ,psql
> can=E2=80=99t change anather table
>

=E2=80=8BI'm losing something in the translation...what you posed isn't a q=
uestion
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.=E2=80=8B