On Thursday, June 10, 2021, Michel Helms <michel(at)togetherdb(dot)com> wrote:
>
> CREATE TABLE "wei rd" (id SERIAL);
> SELECT pg_table_size('wei rd');
>
> So just creating a table containing spaces, the pg_table_size, also
> pg_total_relation_size and maybe other administrative functions fail with
> error message "invalid name syntax".
>
You still have to double-quote the name even if its being passed around in
a string literal.
David J.