On 25/10/12 19:45, Raymond O'Donnell wrote: > 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. > >
Yeah i was referring to PgAdmin, didn't notice that columns shown as serial in PgAdmin are shown like integer nextval(sequence) in \d from psql, i will try to ask in PgAdmin mailing list how they detect a "serial" column because i have tried to replicate the exact setup (ownership included) of one and it doesn't works. Regards, Miguel Angel. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
