Re: Insert a description while creating a table

create table test (
id serial ,
name varchar(50)
);

COMMENT ON TABLE "test"
IS 'MySQL table
id_training_form ... id_form_unique';

comment on COLUMN "test"."id"
is 'greigjreoigjreigjore iojrjiogre' ;

Doc postgresql comment

Rod Taylor wrote:

>On Wed, 2003-08-13 at 07:56, luiz(at)klais(dot)com(dot)br wrote:
>
>
>>Hi,
>>
>>I want to insert descriptions at the columns of my tables but without
>>using the command COMMENT ON. I want to do it together with the table
>>creation. Is that possible?
>>
>>I wanna do something like this:
>>
>>create table test (
>> id serial 'Descripitions about ID',
>> name varchar(50) 'Descriptions about NAME'
>>);
>>
>>
>
>Probably not going to happen in the backend.
>
>However, you should be able to accomplish that with a little bit of Perl
>to pre-process the SQL.
>
>