Re: Stripping apostrophes from data

-----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
shuffledover to Postgres from an older system, and I'm occasionally running into data entered in the old system that
hasapostrophes in it.  (Most recent example: A name field with the word "Today's" in it.)  Given that most of my
interactionswith the database are through perl scripts and php pages, I can't always tell ahead of time what field I
needis 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
apostrophesfor 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-----