Default listing on -Fc files

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: Raw Message | Whole Thread | 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.

Browse pgsql-general by date

  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?