On 25/10/2012 16:32, Linos wrote:
> Hello,
> there is some way to get and old integer primary key column to show the "type"
> serial at table description?
>
> I had a table like this:
>
> CREATE TABLE test
> (
> test_id integer NOT NULL,
> CONSTRAINT test_pkey PRIMARY KEY (test_id),
> );
>
>
> that i would like to see as:
>
> CREATE TABLE test
> (
> test_id serial NOT NULL,
> CONSTRAINT test_pkey PRIMARY KEY (test_id),
> );
PgAdmin manages it somehow, because it's able to show columns as
"serial"... maybe it infers it from the ownership dependency between the
sequence and the column.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie