Character type delimiters - Can they be changed?

I apologize for the second post- I think my digital signature may have
screwed up the first one, so I'm sending this again just to be sure... -NF


Howdy-

Is there a way to change the delimiters for character/date types from
single quotes to any other character?

For instance, if I'm inserting "O'Brien", rather than doing something like
INSERT INTO Names VALUES ('O''Brien'); I'd like to be able to use: INSERT
INTO Names VALUES (~O'Brien~);

I'm new to the list, so a little background on my environment and project:

I'm loading many massive XML files into Postgres using a Java Program.
I'm using PGQSL v6.5.2 on a Debian GNU/Linux 2.2 server.
I'm using the JDBC6.5-1.2 interface.

Although I can (and presently do) just replace ' with '' on all of my
incoming strings, I have some performance problems, and am looking for
ways to cut down on the overhead. Since XML is basically all character
strings, I'm doing the replace routine on almost every field, so cutting
it out would save me a bundle.

I'm a newbie both to Postgres (convert from Oracle) and to JDBC, so I'm
open to any suggestions, & don't assume I've already thought of the
"obvious" solutions!

Thanks


--------------------------------------------------------------------------
Nick Fankhauser

Business: nickf@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
  Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/

Personal: nickf@infocom.com http://www.infocom.com/~nickf