Open SQL and PostgreSQL
The alternative Open SQL interface can be used with PostgreSQL. This section provides some specific details and examples.
Placeholder Syntax
The placeholder syntax for PostgreSQL is a ”$” sign followed by an integer beginning with “1”:
$<n>
Here is an example:
INSERT INTO PICNICTABLE VALUES( $1, $2 )
Placeholders are not a portable feature. Different Access Modules use different placeholder syntax.
Please note that the DB Access Module for PostgreSQL does not support input binding of data. All values are sent as literals upon execution of the SQL statement.
RWDBDataCallback and Open SQL
The data callback classes are not supported in the DB Access Module for PostgreSQL. Attempts to use the data callbacks will result in an RWDBStatus::notSupported error.