Re: Table/Column Constraints

Christopher Kings-Lynne wrote:
>
> > I like this conversation as not a day goes by where I don't wish I could
> > edit the dump of a database rather than keeping structure entirely
> > seperate -- and actually do so in a useful manner. That said, whats the
> > possibility of maintaining comments if the SQL dumps actually became
> > humanly editable?
>
> >From reading the pg_dump source code, pg_dump creates a set of 'COMMENT ON
> ...' statements that should recreate all the comments associated with an
> oid. So - there shouldn't be a problem, should there?

I was thinking of SQL that looks something like:

/*******************************
* TABLE: example
*
* Used to accomplish stuff
*/
CREATE TABLE example
( example_id serial

/* Must be a ZIP or Postal Code */
, region varchar(6) UNIQUE
NOT NULL

/* Descriptive text */
, description varchar(60) NOT NULL
);

I've always made the assumption that anything in the /* */ was dropped.