Column References

Syntax

[[[database.]schema.]table-name.]column-name

Parameters

schema

Specifies a schema, by default public. If schema is any schema other than public, you must supply the schema name. For example:

myschema.thisDbObject

If you specify a database, it must be the current database.

table‑name

One of the following:

  • Name of a table
  • Table alias defined in the query's FROM clause
column‑name

A column name that is unique among all queried tables.

Restrictions

A column reference cannot contain any spaces.