Postgres Pro
Downloads
Home   >   mailing lists

Re: Detecting autoincrement columns - Mailing list pgsql-general

From Melvin Davidson
Subject Re: Detecting autoincrement columns
Date
Msg-id CANu8Fix__Z6v3iuWBLuOw1eWTSPLw5kBZ78HM0wp80Ep_FkZLQ@mail.gmail.com
Whole thread Raw
In response to Re: Detecting autoincrement columns  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Detecting autoincrement columns
List pgsql-general
Tree view
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 <tgl@sss.pgh.pa.us> wrote:
"FarjadFarid\(ChkNet\)" <farjad.farid@checknetworks.com> 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 (pgsql-general@postgresql.org)
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Detecting autoincrement columns
Next
From: Andy Colson
Date:
Subject: Re: 9.5 beta pg_upgrade documentation