Many thanks.
From: Melvin Davidson [mailto:[email protected]] Sent: 02 September 2015 00:20 To: Tom Lane Cc: FarjadFarid(ChkNet); [email protected] Subject: Re: [GENERAL] Detecting autoincrement columns 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. <http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif>
