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

From Tom Lane
Subject Re: Quoting of psql \d output
Date
Msg-id 9870.1072503900@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
List pgsql-patches
"Peter Eisentraut" <peter_e@gmx.net> writes:
> Christopher Kings-Lynne writes:
>> Now you've lost me - how is a user-inputted object name translatable?

> Not all languages use "..." as quote symbols, but if you make them part of
> some string that comes from the backend, it becomes prohibitively hard to
> translate it correctly.

Hm.  This gets back to the point we've discussed before: there is some
confusion between SQL's use of quoted identifiers and the customary
English use of quote marks to set off text that should be distinguished
from the surrounding sentence.

Essentially, Bruce's proposed patch moves the use of quotes in \d table
headers to conform to SQL's "technical" use of quotes, while you are
arguing for sticking with the message style guidelines' "human-oriented"
use of quotes.

I can see merit in both positions.  But I also see merit in the
compromise position of not using quotes at all.  I don't see a strong
need to demarcate table name from surrounding text in a context as
simple as this --- is
        Table "foo"
really any easier to read than
        Table foo
?  And Peter is correct that the former introduces translation issues
when you think about languages that don't customarily use "..." as
quotation marks.

            regards, tom lane

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: fork/exec patch: pre-CreateProcess finalization
Next
From: Claudio Natoli
Date:
Subject: Re: fork/exec patch: pre-CreateProcess finalization