Many thanks.
From: Melvin Davidson [mailto:melvin6...@gmail.com]
Sent: 02 September 2015 00:20
To: Tom Lane
Cc: FarjadFarid(ChkNet); pgsql-general@postgresql.org
Subject: Re: [GENERAL] Detecting autoincrement columns
Try this:
SELECT *
FROM information_schema.columns
WHERE UPPER
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 wrote:
> "FarjadFarid\(ChkNet\)" writes:
> > Can someone please direct me as how to detect columns (serial) with
> > autoincrement optio
"FarjadFarid\(ChkNet\)" 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)
Hi all,
Can someone please direct me as how to detect columns (serial) with
autoincrement option ?
Many thanks.
Best Regards
Farjad Farid
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-
