Try this:
SELECT *
FROM information_schema.columns
WHERE UPPER(column_default) LIKE 'NEXTVAL%'
ORDER BY 1, 2, 3;
On Tue, Sep 1, 2015 at 6:33 PM, Tom Lane <[email protected]> wrote:
> "FarjadFarid\(ChkNet\)" <[email protected]> writes:
> > Can someone please direct me as how to detect columns (serial) with
> > autoincrement option ?
>
> They have a default that depends on a nextval() call.
>
> regards, tom lane
>
>
> --
> Sent via pgsql-general mailing list ([email protected])
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
