Table names in upper case

From: tosites(at)me(dot)com
To: pgsql-docs(at)postgresql(dot)org
Subject: Table names in upper case
Date: 2016-10-12 18:12:33
Message-ID: 20161012181233.1397.66615@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/sql-syntax-lexical.html
Description:

Although this documentation says that "Key words and unquoted identifiers
are case insensitive." it is not possible to use table or column names in
upper case.

If the table or column name was in upper case it is necessary use quotes to
Postgres accept. Exactly the opposite case showed at documentation.

For example:

CREATE TABLE CLIENT(ID INTEGER, NAME TEXT);

SELECT * FROM CLIENT; -- an error will be launched

SELECT * FROM "CLIENT"; -- works

But:

CREATE TABLE client(id INTEGER, name TEXT);

SELECT * FROM CLIENT; -- works

It is, at least, strange.

Cheers.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message rauldmiller 2016-10-13 01:05:44 date ambiguity in view documentation
Previous Message Alex Lydiate 2016-10-12 17:36:58 Fwd: SQL Null