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

From Benoît Bournon
Subject Re: Insert a description while creating a table
Date
Msg-id 3F3A2E04.5090709@adelis.com
Whole thread Raw
In response to Re: Insert a description while creating a table  (Rod Taylor <rbt@rbt.ca>)
List pgsql-sql
<pre wrap="">comment on table "test"
is 'fziofeiozfiezojfezjfeziojfeziojf ezfjioezifj ezio' ;


</pre><br /><br /> Rod Taylor wrote:<br /><blockquote cite="mid1060776408.86938.12.camel@jester" type="cite"><pre
wrap="">OnWed, 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><blockquote type="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: "ProgHome"
Date:
Subject: Re: How to optimize this query ?
Next
From: Raymond Chui
Date:
Subject: Why table has drop, but the foreign key still there?