> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm.poure@freesurf.fr]
> Sent: 02 October 2001 16:34
> To: pgadmin-hackers@postgresql.org
> Subject: [pgadmin-hackers] Column lenght
>
>
> 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 property editor show the correct column lenght.
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.