pg_restore -t

Started by "Rodríguez Rodríguez, Pere"over 21 years ago1 messagesgeneral
Jump to latest

Hello,

I have a backup make with pg_dump and I want to restore only a table
definition.

I run pg_restore -s -t table_name ./backup_file > script.sql and it runs ok
but in the script generated there aren't any alter table statment. So, I
haven't primary key, and foreign keys in the script. Is this correct?

Thanks in advance,

Pere Rodríguez
Dpt. d'informàtica
Hospital de Palamós
Girona - Spain