issuing insert preparedstatement queries with default values - Mailing list pgsql-jdbc

From Johnny Luong
Subject issuing insert preparedstatement queries with default values
Date
Msg-id 4B47C7E9.4030000@trustcommerce.com
Whole thread Raw
Responses Re: issuing insert preparedstatement queries with default values  (dmp <danap@ttc-cmc.net>)
List pgsql-jdbc
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Is there a way to use the DEFAULT per column value on an INSERT sql in
PG through the PreparedStatement JDBC API?  It'd be nice so that I don't
have to maintain a secondary list of PreparedStatements or a list of
default values maintained outside of the database definition.

e.g:

INSERT INTO foo (a, b) (?, ?)

where b has a default value in the database and a is something that I
might set to some other value.


I'm using postgresql-8.3-603.jdbc4.jar against a 8.3 postgresql server.

Thanks,
Johnny
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAktHx+kACgkQnQTBLXttTeVEmgCePgPqSGOtZvii/nGWEVaGeF+l
VX4An0LVEB9Rhlsc0s8j91oTwLOoKS4L
=s1Fo
-----END PGP SIGNATURE-----

pgsql-jdbc by date:

Previous
From: "John T. Dow"
Date:
Subject: Optimistic locking with multiple rows
Next
From: dmp
Date:
Subject: Re: issuing insert preparedstatement queries with default values