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.