pg_restore -t table doesn't restore PKEY

Поиск
Список
Период
Сортировка
От Jan C.
Тема pg_restore -t table doesn't restore PKEY
Дата
Msg-id AANLkTi=vaYPG4Wq+vohLY56F5ETrFXTNZ-EzCXTiMf4C@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_restore -t table doesn't restore PKEY
Список pgsql-general
Hello,
I have dump of an entire database and I'm trying to restore only one named table:

> pg_restore  --format=c -C -U myUser -d myDB /tmp/mydump -t my_table

The command completes without errors/warnings but the resulting table in the database is missing the PKEY constraint !

Is this done on purpose ? What is the correct way to restore a named table ? 

I know I can use the -t switch during the dump and then restore without using -t but I would like to avoid this solution. The files I can work on are dumps of the entire DB.

Thanks for your help,
Jan

В списке pgsql-general по дате отправления: