in reply to Escaping SQL correctly
2/ Test the queries against this mockup database instance. It gives you ability to check the semantically wrong queries - relation xyz does not exist, for instance, not only syntactically erroneous queries.pg_dump -s dbname > dbname.dump createdb dbname_fake psql dbname_fake \i dbname.dump
...and you will not have any problem with escaping, I hope :)<sql>select * from xyz where col1 = ?;</sql> <params> <param>123.5</param> </params>
|
|---|