How to find if a column is a "serial" column?

From: Dave Bartmess <dingodave(at)edingo(dot)net>
To: PGSql List <pgsql-jdbc(at)postgresql(dot)org>
Subject: How to find if a column is a "serial" column?
Date: 2003-12-20 22:53:09
Message-ID: 1071960789.4719.5.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I'm trying to write an insert routine, but I want to have the serial
column(s) excluded from the update/insert SQL commands, which I'm
building on the fly.

How do I determine if a column has been declared as a serial, since it
only comes back in getColumns() as java.sql.Types.INTEGER in the
resultset column "DATA_TYPE"?

Thanks!
--
David A. Bartmess
Software Configuration Manager / Sr. Software Developer
eDingo Enterprises
http://edingo.net

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2003-12-21 06:11:32 Re: How to find if a column is a "serial" column?
Previous Message Christian Rengstl 2003-12-20 19:06:07 Newbie question