[GENERAL] Character type delimiters - can they be changed?
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: [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko Co. Software Consulting Services
http://www.ontko.com/
Personal: [EMAIL PROTECTED] http://www.infocom.com/~nickf
smime.p7s
[GENERAL] 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: [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko Co. Software Consulting Services http://www.ontko.com/
Personal: [EMAIL PROTECTED] http://www.infocom.com/~nickf
