Re: Insert a description while creating a table

Поиск
Список
Период
Сортировка
От Benoît Bournon
Тема Re: Insert a description while creating a table
Дата
Msg-id 3F3A2E04.5090709@adelis.com
обсуждение исходный текст
Ответ на Re: Insert a description while creating a table  (Rod Taylor <rbt@rbt.ca>)
Список 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 по дате отправления:

Предыдущее
От: "ProgHome"
Дата:
Сообщение: Re: How to optimize this query ?
Следующее
От: Raymond Chui
Дата:
Сообщение: Why table has drop, but the foreign key still there?