| From: | Isaac Morland <isaac(dot)morland(at)gmail(dot)com> |
|---|---|
| To: | Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg14 psql broke \d datname.nspname.relname |
| Date: | 2021-10-11 23:41:08 |
| Message-ID: | CAMsGm5c-YHNya4s7Ye4Qt8viv+a6t6CRTfa7RnGX_KunBXCrCA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, 11 Oct 2021 at 19:35, Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>
wrote:
> But since we allow tables and schemas with dotted names in them, I'm
> uncertain what \d foo.bar.baz is really asking.
>
FWIW, it’s absolutely clear to me that "." is a special character which has
to be quoted in order to be in an identifier. In other words, a.b.c is
three identifiers separated by two period punctuation marks; what exactly
those periods mean is another question. If somebody uses periods in their
names, they have to quote those names just as if they used capital letters
etc.
But that's just my impression. I comment at all because I remember looking
at something to do with the grammar (I think I wanted to implement ALTER …
RENAME TO newschema.newname) and noticed that a database name could be
given in the syntax.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-10-11 23:49:49 | Re: pg14 psql broke \d datname.nspname.relname |
| Previous Message | Mark Dilger | 2021-10-11 23:35:17 | Re: pg14 psql broke \d datname.nspname.relname |