X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 6272AD1B524
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 13 Aug 2003 12:32:13 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 09306-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 13 Aug 2003 09:30:40 -0300 (ADT)
Received: from neptune.adelis.net (neptune.adelis.net [195.115.171.102])
	by svr1.postgresql.org (Postfix) with ESMTP id 487FED1C4B8
	for <pgsql-sql@postgresql.org>; Wed, 13 Aug 2003 09:31:53 -0300 (ADT)
Received: from icqmail.com (ben.adelis.net [195.115.171.16])
	by neptune.adelis.net (Postfix) with ESMTP
	id 4C54A7921D; Wed, 13 Aug 2003 14:23:40 +0200 (CEST)
Message-ID: <3F3A2FBE.2050408@icqmail.com>
Date: Wed, 13 Aug 2003 14:31:58 +0200
From: BenLaKnet <benlaknet@icqmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; fr-FR; rv:1.4) Gecko/20030624
X-Accept-Language: fr, en-us, en, ja
MIME-Version: 1.0
To: Rod Taylor <rbt@rbt.ca>
Cc: luiz@klais.com.br, pgsql-sql@postgresql.org
Subject: Re: Insert a description while creating a table
References: <Pine.LNX.4.44.0308130851230.1254-100000@elessar.klais>
	<1060776408.86938.12.camel@jester>
In-Reply-To: <1060776408.86938.12.camel@jester>
Content-Type: multipart/alternative;
	boundary="------------020701020506020801050708"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/129
X-Sequence-Number: 14745

This is a multi-part message in MIME format.
--------------020701020506020801050708
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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@klais.com.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.
>  
>

--------------020701020506020801050708
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
  <title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
create table test (<br>
&nbsp;&nbsp;&nbsp;&nbsp; id serial ,<br>
&nbsp;&nbsp;&nbsp;&nbsp; name varchar(50) <br>
&nbsp;);<br>
<br>
&nbsp;<br>
&nbsp;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 Taylor wrote:<br>
<blockquote type="cite" cite="mid1060776408.86938.12.camel@jester">
  <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>
  <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>
</body>
</html>

--------------020701020506020801050708--