Thread: pg_restore -t

pg_restore -t

From
"Rodríguez Rodríguez, Pere"
Date:

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