Re: [GENERAL] pg_restore -t table doesn't restore PKEY

2010-10-29 Thread Jan C.
aint is NOT listed when I do pg_restore  -l /tmp/mydump -t my_table In any case, shouldn't the documentation describe more the pg_restore -t command ? It's really misleading and one can discover this only by running into problems. Thanks for your help, Jan On Fri, Oct 29, 2010

[GENERAL] pg_restore -t table doesn't restore PKEY

2010-10-29 Thread Jan C.
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 pu