RE: Table/Column Constraints

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: Table/Column Constraints
Date: 2000-11-21 07:10:04
Message-ID: NEBBIOAJBMEENKACLNPCGEIJCCAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> CREATE TABLE example
> ( example_id serial
>
> -- Must be a ZIP or Postal Code
> , region varchar(6)
>
> -- Descriptive text
> , description varchar(60)
> );

Actually - this is something I _could_ do.

As the pg_dump is running, it shouldn't be too hard to select the comment
associated with each entity as it is being dumped. ie. In the example
above, the comments for each attribute would be retrieved from
pg_description (or whatever) and output as '-- ...' comments.

Then, if the COMMENT ON statements are also still dumped at the bottom, you
get the ability to see comments conveniently in your dump, but with the
ability to still hand-edit them before restoring the dump...

Chris

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dan Wilson 2000-11-21 07:27:48 Fw: DB and Table Permissions
Previous Message Vadim Mikheev 2000-11-21 06:18:25 Re: [HACKERS] Re: pgsql/src/backend/access/transam (xlog.c)