Re: integer column to serial "type"

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