Re: [SQL] Insert a description while creating a table

Thu, 14 Aug 2003 16:34:43 -0700

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, [EMAIL PROTECTED] 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.

Reply via email to