handling special characters in sql strings - Mailing list pgsql-sql

Hi,

I need to insert and retrieve strings containing special characters (e.
g. "'") and I want a C function to prepare my strings automatically. Is
it ok to just insert a "\" before each special character? And what range
of characters will need this handling?

Thanks,

Markus