Обсуждение: Pg-restore

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

Pg-restore

От
"Ramzi M. Zeid"
Дата:
Hello all,

Is the any way or command to make a restore for a single table from a TAR
file that contains many table to another DB.

Regards

Ramzi

Re: Pg-restore

От
Richard Huxton
Дата:
Ramzi M. Zeid wrote:
> Hello all,
>
> Is the any way or command to make a restore for a single table from a TAR
> file that contains many table to another DB.

pg_restore -t <tablename> will work if it's a dump in the correct
format. See the manuals for details.

If it's just a bunch of INSERTS in a file you've built yourself, then
clearly not.

--
   Richard Huxton
   Archonet Ltd