issuing insert preparedstatement queries with default values

From: Johnny Luong <johnny(dot)luong(at)trustcommerce(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: issuing insert preparedstatement queries with default values
Date: 2010-01-09 00:03:53
Message-ID: 4B47C7E9.4030000@trustcommerce.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message dmp 2010-01-09 02:15:01 Re: issuing insert preparedstatement queries with default values
Previous Message John T. Dow 2010-01-02 20:22:07 Optimistic locking with multiple rows