Andrew Edson wrote:
Is there some program or procedure for stripping apostrophes (') from
data in the db? Most of our data has been shuffled over to Postgres
from an older system, and I'm occasionally running into data entered
in the old system that has apostrophes in it. (Most recent example: A
name field with the word "Today's" in it.) Given that most of my
interactions with the database are through perl scripts and php pages,
I can't always tell ahead of time what field I need is going to
contain data that's deadly to my statements.
Alternately, is there some way of inserting or selecting data from the
db which doesn't require the use of apostrophes for non-numeric fields?
------------------------------------------------------------------------
Luggage? GPS? Comic books?
Check out fitting gifts for grads
<http://us.rd.yahoo.com/evt=48249/*http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&cs=bz>
at Yahoo! Search.
In php you can use |pg_escape_string function:
http://us3.php.net/manual/en/function.pg-escape-string.php|
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
