Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

query manipulation



I'm trying to find a way to manipulate some poorly written queries in which I don't have access to the application source. I can't do it at the Postgresql server, so I'm thinking of attacking it at the jdbc driver.

I was thinking of a wrapper that would look at and alter the SQL before it went to the server. Anyone know of something like this? Specifically, I'm trying to drop "FOR UPDATE column name" off of some queries. They were written for Oracle, but Postgresql uses "FOR UPDATE table name". I'm not a Java programmer, but I won't let that stop me if it is required.

Randall




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group