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

2003-08-14 Thread BenLaKnet
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, [E

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

2003-08-14 Thread Reinoud van Leeuwen
On Wed, Aug 13, 2003 at 02:54:59PM +0200, Christoph Haller wrote: > \dd test shows > > Object descriptions > Schema | Name | Object | Description > +--++- > (0 rows) > > This is odd. OK, I know the doc says > \dd [ pattern ] > > Shows the description

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

2003-08-14 Thread Benoît Bournon
comment on table "test" is 'fziofeiozfiezojfezjfeziojfeziojf ezfjioezifj ezio' ; 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 to

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

2003-08-14 Thread Christoph Haller
> > 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', > >

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

2003-08-14 Thread Rod Taylor
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

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

2003-08-14 Thread Christoph Haller
> On Wed, Aug 13, 2003 at 02:54:59PM +0200, Christoph Haller wrote: > > \dd test shows > > > > Object descriptions > > Schema | Name | Object | Description > > +--++- > > (0 rows) > > > > This is odd. OK, I know the doc says > > \dd [ pattern ] > > > >

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

2003-08-14 Thread luiz
Hi Christoph, I'm thinking that the best solution is create a script in perl or python that executes de COMMENT command to me. My initial idea would be comment my columns in a standard way and then run the script. My comment that will turn into description will start with "/*$" instead of the

[SQL] Insert a description while creating a table

2003-08-14 Thread luiz
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) '