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@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
