Hi Xiao,
Perhaps you could try using Python's string "replace" method to eliminate
special characters from your input before inserting it into the database?
Marina.
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
Hi all,
I'm a newbie to postgresql. I'm trying to extract data from a MDL sdf file and
deposit them to my database. Some data item in sdf contains single quote(\')
or four dollars($$$$) which denotes the end of a record in sdf file.
I use the python interface pgdb to do this, and I have googled and tried
several ways to quote the string but no success. There is a function
"escape_string" in the classic python interface pg, but not in pgdb.
Would someone tell me how to solve this problem ?
Thanks a lot.
Xiao Jianfeng
_______________________________________________
PyGreSQL mailing list
[email protected]
http://mailman.vex.net/mailman/listinfo/pygresql
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now._______________________________________________
PyGreSQL mailing list
[email protected]
http://mailman.vex.net/mailman/listinfo/pygresql
