Re: Insert a description while creating a table - Mailing list pgsql-sql

From BenLaKnet
Subject Re: Insert a description while creating a table
Date
Msg-id 3F3A2FBE.2050408@icqmail.com
Whole thread Raw
In response to Re: Insert a description while creating a table  (Rod Taylor <rbt@rbt.ca>)
List pgsql-sql
create table test (<br />      id serial ,<br />      name varchar(50) <br />  );<br /><br />  <br />  COMMENT ON
TABLE"test"<br /> IS 'MySQL table<br /> id_training_form ... id_form_unique';<br /><br /> comment on COLUMN
"test"."id"<br/> is 'greigjreoigjreigjore iojrjiogre' ;<br /><br /><br /> Doc postgresql comment<br /><br /><br /> Rod
Taylorwrote:<br /><blockquote cite="mid1060776408.86938.12.camel@jester" type="cite"><pre wrap="">On Wed, 2003-08-13 at
07:56,<a class="moz-txt-link-abbreviated" href="mailto:luiz@klais.com.br">luiz@klais.com.br</a> wrote:
</pre><blockquotetype="cite"><pre wrap="">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'
);   </pre></blockquote><pre wrap="">
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. </pre></blockquote>

pgsql-sql by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Insert a description while creating a table
Next
From: Christoph Haller
Date:
Subject: Re: Insert a description while creating a table