How to Specify Delimited Identifiers
You can specify delimited identifiers for database objects in the following circumstances:
• Within the report specification code
• On the command line within a command to run a report
• On the command line in response to a prompt for runtime substitution of a variable
To specify a delimited identifier in the report specification code, as a parameter on the command line, or in response to an Ingres prompt on the command line, enclose the delimited identifier within double quotes (") and escape any embedded double quotes by doubling them. For convenience, we refer to this as editable format. You can specify delimited identifiers as follows:
You can use delimited identifiers in the following circumstances:
• As a table, view, or synonym:
.data "Dave's table"
• As a column name:
.print "Stocks & Bonds"
• As a correlation name and column name in correlation_name.column_name constructs:
.query
select "t-1"."col 1" as col1, "t-2"."col 2"
as col2
from table_one "t-1", table_two "t-2"
• When using schemas for owner qualification, for either or both the schema name and/or object name, as follows:
"schema 1".table2
dave."Dave's table"
"schema 1"."view table1 & table2"
• On the command line, as a username for the ‑u flag, groupid parameter for the ‑G flag, or database object in a command parameter
If your operating system requires additional delimiting and dereferencing quotes for delimited identifiers on the command line, see the Command Reference Guide.
When using schemas for owner qualification or when specifying a user ID on the command line, the schema or user ID must be enclosed in double quotes if it does not conform to the conventions for regular identifiers. If a schema or user ID contains characters unacceptable in a regular identifier, such as in Da Vinci or O'Neil, then all objects created by that user can have a schema name that must be specified as a delimited identifier in double quotes.
In addition, the DBA can specify at database creation time whether Ingres stores user IDs in uppercase, lowercase, or mixed case when impersonating that user with the ‑u flag on the command line.
Also, any schema name that Ingres creates by default based on that user ID is stored in mixed case and must be specified as a delimited identifier, in double quotes, when qualifying an object with an owner name.
For more information on schema names or specifying case conventions for user identifiers in a particular database, see the Database Administrator Guide. For information about specifying embedded quotes and other special characters in delimited identifiers, see the SQL Reference Guide.