-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
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?
Uhmm just prepare all your statements and this shouldn't be an issue.
Joshua D. Drake
>
>
> ---------------------------------
> Luggage? GPS? Comic books?
> Check out fitting gifts for grads at Yahoo! Search.
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGycGdATb/zqfZUUQRAkZpAJ0dbBVc8Y/Sk5mIwMICin1UyL3eWwCfTlLJ
uAHznl5Cf0geQYLvOcUs+ks=
=t9rL
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
