So I'd have to do:
pg_restore -l /tmp/mydump | grep my_table > /tmp/mytable_lines
pg_restore --format=c -C -U myUser -d myDB /tmp/mydump -L /tmp/mytable_lines
It looks like I have to use "grep" to look for my table and not "-t
my_table" because the PKEY constraint is NOT listed when I do
pg_r
"Jan C." 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 !
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
