[PyGreSQL] How to quote strings contain single quote and "$$$$"?

[fdu.xiaojf at gmail.com]

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