Re: Column COMMENTs in CREATE TABLE? - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Column COMMENTs in CREATE TABLE?
Date
Msg-id CAKFQuwZmn1X1ix==hKDJByEYP4MNZbsBMhOcW59JZ3LwZkZ32w@mail.gmail.com
Whole thread Raw
In response to Column COMMENTs in CREATE TABLE?  (Marko Tiikkaja <marko@joh.to>)
Responses Re: Column COMMENTs in CREATE TABLE?  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Re: Column COMMENTs in CREATE TABLE?  (David Fetter <david@fetter.org>)
List pgsql-hackers
On Sat, Jul 2, 2016 at 12:55 PM, Marko Tiikkaja <marko@joh.to> wrote:

What I would prefer is something like this:

CREATE TABLE foo(
  f1 int NOT NULL COMMENT
    'the first field',
  f2 int NOT NULL COMMENT
    'the second field',
...
);

which would ensure the comments are both next to the field definition they're documenting and that they make it all the way to the database. I looked into the biggest products, and MySQL supports this syntax.  I couldn't find any similar syntax in any other product.


​+1 for the idea - though restricting it to columns would not be ideal.


CREATE TABLE name 
COMMENT IS 
'Table Comment Here'
(
col1 serial COMMENT IS 'Place comment here'
)​;

David J.

pgsql-hackers by date:

Previous
From: Marko Tiikkaja
Date:
Subject: Column COMMENTs in CREATE TABLE?
Next
From: Vladimir Sitnikov
Date:
Subject: Re: Statistics Injection