Vertica Analytics Platform Version 9.2.x Documentation

Column References

Syntax

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

Parameters

[database.]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:

  • The name of a table
  • A 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.