On 25/10/12 17:39, Tom Lane wrote:
> Linos <info@linos.es> writes:
>> there is some way to get and old integer primary key column to show the "type"
>> serial at table description?
>
> No, because there is no such type. "serial" is just a convenient macro
> that you can use in CREATE TABLE; it's not a real type.
>
> regards, tom lane
>
>
Yeah, i knew it's not a real type and supposed the outcome, i only wanted to be
sure, i find much more pleasant to see:
test_id serial NOT NULL,
than
test_id integer NOT NULL DEFAULT nextval('test_test_id_seq'::regclass),
but i can live with it, thanks!
Regards,
Miguel Angel.