"Jan C." <chaljan@xxxxxxxxx> writes: > 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 ! Use pg_restore -l, then extract the lines relevant to your table, then pg_restore -L to restore just the named items. I think there's a TODO to make pg_restore's -t switch work more like pg_dump's, but at the moment they're really quite different animals. pg_restore doesn't have any logic about "oh, if he asked for this item I bet he wants that one too". regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
