Re: Column lenght

2001-10-02 Thread Jean-Michel POURE
>This should be fixed now. Char columns get converted to bpchar in >PostgreSQL, but you can't specify a length for bpchar! > >All columns will now display correctly as char(n). > >Regards, Dave. Hello my friend, The only thing we can trust is plain 'source code' not PostgreSQL derived or user

Re: Column lenght

2001-10-02 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 02 October 2001 16:34 > To: [EMAIL PROTECTED] > Subject: [pgadmin-hackers] Column lenght > > > Hello, > > Try the following query: > create table essai( > I

Column lenght

2001-10-02 Thread Jean-Michel POURE
Hello, Try the following query: create table essai( ID char(12) not null, primary key (id) ); The definition pane displays no lenght: CREATE TABLE "essai" ( "id" bpchar NOT NULL, CONSTRAINT "essai_pkey" PRIMARY KEY ("id") ); The