From: | "FarjadFarid\(ChkNet\)" <farjad(dot)farid(at)checknetworks(dot)com> |
---|---|
To: | "'Melvin Davidson'" <melvin6925(at)gmail(dot)com>, "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Detecting autoincrement columns |
Date: | 2015-09-02 08:42:27 |
Message-ID: | 003301d0e55b$4c317a40$e4946ec0$@checknetworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Many thanks.
From: Melvin Davidson [mailto:melvin6925(at)gmail(dot)com]
Sent: 02 September 2015 00:20
To: Tom Lane
Cc: FarjadFarid(ChkNet); pgsql-general(at)postgresql(dot)org
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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
"FarjadFarid\(ChkNet\)" <farjad(dot)farid(at)checknetworks(dot)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(at)postgresql(dot)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. <http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif>
From | Date | Subject | |
---|---|---|---|
Next Message | FarjadFarid(ChkNet) | 2015-09-02 09:05:17 | Serial initial and incremental value |
Previous Message | Andy Colson | 2015-09-02 02:12:27 | Re: 9.5 beta pg_upgrade documentation |