Re: Quoting of psql \d output - Mailing list pgsql-patches

From Tom Lane
Subject Re: Quoting of psql \d output
Date
Msg-id 3076.1072191640@sss.pgh.pa.us
Whole thread Raw
In response to Re: Quoting of psql \d output  ("Peter Eisentraut" <peter_e@gmx.net>)
Responses Re: Quoting of psql \d output  ("Peter Eisentraut" <peter_e@gmx.net>)
List pgsql-patches
"Peter Eisentraut" <peter_e@gmx.net> writes:
> Bruce Momjian writes:
>> psql \d always double-quotes table names:

> Yes, and that is conforming to message style rules.  Please leave it at that.

The problem is that it is double-quoting a qualified name, which is
something we generally don't produce in messages.  I think it's actively
misleading.

A simpler but uglier solution would be to quote the schema and table
names separately:

    Table "public"."foo"

            regards, tom lane

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Quoting of psql \d output
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: [GENERAL] Temporary tables and miscellaneous schemas