Обсуждение: please help me

Поиск
Список
Период
Сортировка

please help me

От
"zhangtingting"
Дата:
<div style="font:14px/1.5 'Lucida Grande', '微软雅黑';color:#333;"><p style="font:14px/1.5 'Lucida Grande';margin:0;">hi:<p
style="font:14px/1.5'Lucida Grande';margin:0;">i have e question for postgres,when i restore backup from pg_dump ,psql
can’tchange anather table</div> 

Re: please help me

От
"David G. Johnston"
Дата:
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