Re: Column lenght

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm(dot)poure(at)freesurf(dot)fr]
> Sent: 02 October 2001 16:34
> To: pgadmin-hackers(at)postgresql(dot)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.