Re: [GENERAL] Detecting autoincrement columns

2015-09-02 Thread FarjadFarid(ChkNet)
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

Re: [GENERAL] Detecting autoincrement columns

2015-09-01 Thread Melvin Davidson
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

Re: [GENERAL] Detecting autoincrement columns

2015-09-01 Thread Tom Lane
"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

Re: [GENERAL] Detecting autoincrement columns

2015-09-01 Thread FarjadFarid(ChkNet)
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: