Re: sequences and pg_type - Mailing list pgsql-hackers

From Tom Lane
Subject Re: sequences and pg_type
Date
Msg-id 1585.1062897567@sss.pgh.pa.us
Whole thread Raw
In response to sequences and pg_type  (pw <p.willis@telus.net>)
List pgsql-hackers
pw <p.willis@telus.net> writes:
> I have a table with a serial type in it as a record id.
> The type of this object comes back as int4 when I query via
> pg_type.
> How can I distinguish this counter type from just a plain int4?

Well, you can't, because serial isn't actually a type in Postgres.
As the manual tries to explain, serial is just a shorthand for creating
an integer column whose default is a nextval() call on a sequence.
So the way to tell is to look for a default expression of that kind.
        regards, tom lane


pgsql-hackers by date:

Previous
From: pw
Date:
Subject: sequences and pg_type
Next
From: pw
Date:
Subject: Re: sequences and pg_type