Reserved word: OWNER

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: magnus(dot)johan(dot)hedberg(at)gmail(dot)com
Subject: Reserved word: OWNER
Date: 2022-05-13 07:40:57
Message-ID: 165242765714.661.4834758786310673627@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/14/sql-keywords-appendix.html
Description:

You say it's a non-reserved word, but on this page:
https://www.postgresql.org/docs/current/sql-alterdatabase.html#:~:text=To%20alter%20the%20owner%2C%20you,default%20tablespace%20of%20the%20database.

you clearly use OWNER as a reserved word:

ALTER DATABASE name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER |
SESSION_USER }

and if I try to use OWNER as a column name in pgAdmin, it is marked blue (ie
a reserved word). So which is it?

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Thom Brown 2022-05-13 12:53:05 Re: Reserved word: OWNER
Previous Message David G. Johnston 2022-05-11 17:00:15 Re: SET TRANSACTION SNAPSHOT sounds like replicated environment but isn't