| From: | "Rodríguez Rodríguez, Pere" <prr(at)hosppal(dot)es> |
|---|---|
| To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | pg_restore -t |
| Date: | 2004-07-30 11:52:01 |
| Message-ID: | B35596C2EFF3D2118EE100A0C94B2A60014BFB0E@palamos_nt |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christophe Musielak | 2004-07-30 12:32:02 | 7.2 - 7.4.2 production server migration issue |
| Previous Message | m.e.bruche@lse.ac.uk | 2004-07-30 11:39:30 | Re: Moving tables between schemas |