Re: Be more clear what names can be used for tables with "CREATE TABLE"?

a) Don't forget: constraint, function, procedure, trigger.

b) The hint applies to each of such objects: CREATE [TABLE|VIEW|FUNCTION|...]. To avoid such redundancy we could extend and clarify the definition of 'SQL object / local object / global object' within the glossary and refer to it.

c) In general we have 3 levels (namespaces) where object names are unique across the same or different types.

• cluster-level: database name, tablespace, replication origin, subscription for logical replication, role, ...?
  
• database-level: schema, extension, collation, data type cast, ...?
  
• schema-level: table, index, view, materialized view, foreign table, sequence, constraint, function, procedure, trigger, operator, ...?

--

Jürgen Purtz