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