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 3C980D1C4CC for ; Wed, 13 Aug 2003 12:24:58 +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 12896-03 for ; Wed, 13 Aug 2003 09:23:25 -0300 (ADT) Received: from neptune.adelis.net (neptune.adelis.net [195.115.171.102]) by svr1.postgresql.org (Postfix) with ESMTP id 8139FD1C4C7 for ; Wed, 13 Aug 2003 09:24:46 -0300 (ADT) Received: from adelis.com (ben.adelis.net [195.115.171.16]) by neptune.adelis.net (Postfix) with ESMTP id 4286E79191 for ; Wed, 13 Aug 2003 14:16:18 +0200 (CEST) Message-ID: <3F3A2E04.5090709@adelis.com> Date: Wed, 13 Aug 2003 14:24:36 +0200 From: =?ISO-8859-1?Q?Beno=EEt_Bournon?= 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 Cc: pgsql-sql@postgresql.org Subject: Re: Insert a description while creating a table References: <1060776408.86938.12.camel@jester> In-Reply-To: <1060776408.86938.12.camel@jester> Content-Type: multipart/alternative; boundary="------------020508060001040505090805" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/153 X-Sequence-Number: 14769 This is a multi-part message in MIME format. --------------020508060001040505090805 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit comment on table "test" is 'fziofeiozfiezojfezjfeziojfeziojf ezfjioezifj ezio' ; 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. > > --------------020508060001040505090805 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit
comment on table "test"
is 'fziofeiozfiezojfezjfeziojfeziojf ezfjioezifj ezio' ;




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.
  
--------------020508060001040505090805--