Re: [HACKERS] Table/Column Constraints

[Rod Taylor]

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.