quote_sql_identifier
Description:
Use this method to get a correctly quoted (if necessary) SQL identifier which can be used in SQL statements, from id
.
If id
is already correctly quoted for this, then a copy of id
may be returned.
This method may add double quotes (or other characters) around id
:
- if
id
is a reserved SQL keyword (such as SELECT, INSERT, ...) - if
id
contains non allowed characters such as spaces, or if it starts with a digit - in any other event as necessary for this, depending on the the options passed when opening the this connection, and specifically the GDA_CONNECTION_OPTIONS_SQL_IDENTIFIERS_CASE_SENSITIVE option.
One can safely pass an already quoted id
to this method, either with quoting characters allowed by this
or using the double quote (") character.
Parameters:
this |
a Connection object |
id |
an SQL identifier |
Returns:
a new string, to free with g_free once not needed anymore |