Skip site navigation (1) Skip section navigation (2)

Re: Column lenght

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Column lenght
Date: 2001-10-02 16:23:46
Message-ID: AA30E7BCCA5C1D4E88A231900F8325C00B5B@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackers

> -----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.

pgadmin-hackers by date

Next:From: Bruce MomjianDate: 2001-10-02 16:27:19
Subject: Re: What about CREATE OR REPLACE FUNCTION?
Previous:From: Dave PageDate: 2001-10-02 16:09:21
Subject: Re: Table modification

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group