Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Correct way to send a composite type to Postgres
- From: Kris Jurka <books(at)ejurka(dot)com>
- To: Jason Tesser <jasontesser(at)gmail(dot)com>
- Cc: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
- Subject: Re: Correct way to send a composite type to Postgres
- Date: Thu, 18 Feb 2010 00:17:29 -0500 (EST)
- Message-id: <alpine.BSO.2.00.1002180011520.30823@leary.csoft.net> <text/plain>
On Tue, 16 Feb 2010, Jason Tesser wrote:
I have a composite type that is an IN parameter for a Stored Function. How do I construct the type in Java? I know in Postgres I can do row(....) I was hoping for something a little more Javaish instead to having to build that String. Can I extend PGObject to accomplish this?
Currently there isn't a great way to do this with the PG JDBC driver. You can encapsulate the ugliness with PGObject, but you can't avoid it. If you have a type that extends PGObject all you need to do is override the toString method to format the data as the server expects it.
Kris Jurka
- Follow-Ups:
- Re: Correct way to send a composite type to Postgres
- From: Jason Tesser
- Re: Correct way to send a composite type to Postgres
- References:
- Correct way to send a composite type to Postgres
- From: Jason Tesser
- Correct way to send a composite type to Postgres
- Prev by Date: Column is of type date but expression is of type text
- Next by Date: Re: Column is of type date but expression is of type text
- Previous by thread: Correct way to send a composite type to Postgres
- Next by thread: Re: Correct way to send a composite type to Postgres
- Indexes: