quote_sql_identifier


Description:

[ Version ( since = "4.0.3" ) ]
public string quote_sql_identifier (string id)

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