Re: integer column to serial "type" - Mailing list pgsql-general

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.