On Sat, 2021-10-30 at 11:08 +0000, Daniel Westermann (DWE) wrote:
> HI all,
>
> in the documentation for CREATE TABLE we have this sentence:
>
> "The name of the table must be distinct from the name of any other table, sequence, index, view, or foreign table in
thesame schema."
>
> At least materialized views are missing:
>
> Domains are also missing:
>
> ... but that maybe is covered by the next paragraph?
>
> "CREATE TABLE also automatically creates a data type that represents the composite type corresponding to one row of
thetable.
> Therefore, tables cannot have the same name as any existing data type in the same schema."
Technically speaking, it is "objects stored in pg_class".
Perhaps we can refer to the documentation of "pg_class", which will in turn refer you to "relkind".
Yours,
Laurenz Albe