pg_restore -t - Mailing list pgsql-general

From Rodríguez Rodríguez, Pere
Subject pg_restore -t
Date
Msg-id B35596C2EFF3D2118EE100A0C94B2A60014BFB0E@palamos_nt
Whole thread Raw
List pgsql-general

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

pgsql-general by date:

Previous
From: "Jason Tesser"
Date:
Subject: Re: Wal logs
Next
From: Christophe Musielak
Date:
Subject: 7.2 - 7.4.2 production server migration issue