| From: | Francisco Reyes <lists(at)stringsutils(dot)com> |
|---|---|
| To: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Default listing on -Fc files |
| Date: | 2009-09-16 13:41:41 |
| Message-ID: | cone.1253108501.197903.12236.1000@shelca |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Is there a way to tell to which table a DEFAULT rule belongs to?
Example:
Have multiple files with serial. The sequence is setup as a default. Because
all tables have the same structure the DEFAULT lines on a file pg_dumped
with -Fc look the same.
The lines look like
DEFAULT public id user
DEFAULT public id user
DEFAULT publid id user
They have different IDs, but I don't know how to tell to which table they
belong so when I do restores of selected tables I would be able to restore
the proper defaults.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Mah | 2009-09-16 13:42:16 | Re: I need a Postgres Admin $130K + 20K in NYC Any Ideas? |
| Previous Message | Nathan Widmyer | 2009-09-16 13:20:20 | Current state of XML capabilities in PostgreSQL? |