Prepared Statement with apostrophes

Databases
1

In PostgreSQL 9.1, does a prepared statement allow searches with apostrophes?

For example:

[code]dim ps as PostgreSQLPreparedStatement = _
db.Prepare(“SELECT * FROM customers WHERE lastname = $1”)

ps.bind(0,“O’Conner”)
dim rs as RecordSet = ps.SQLSelect
[/code]

Or do i have to do something like this:

[code]dim ps as PostgreSQLPreparedStatement = _
db.Prepare(“SELECT * FROM customers WHERE lastname = $1”)

ps.bind(0,“O’'Conner”)
dim rs as RecordSet = ps.SQLSelect
[/code]

2

That is the WHOLE point (well one of them) about using Prepared Statements… “YOU” don’t have to concern your self with escaping characters or SQL injection etc.

3

OK, thanks. I just wanted to be sure.