Re: Quoting of psql \d output

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Peter Eisentraut" <peter_e(at)gmx(dot)net>
Cc: chriskl(at)familyhealth(dot)com(dot)au, pgman(at)candle(dot)pha(dot)pa(dot)us, pgsql-patches(at)postgresql(dot)org
Subject: Re: Quoting of psql \d output
Date: 2003-12-27 05:45:00
Message-ID: 9870.1072503900@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

"Peter Eisentraut" <peter_e(at)gmx(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2003-12-27 06:44:54 Re: Strange permission problem regarding pg_settings
Previous Message Alex J. Avriette 2003-12-27 02:41:45 Re: feature request: \qf datatype

Browse pgsql-patches by date

  From Date Subject
Next Message Claudio Natoli 2003-12-27 06:16:14 Re: fork/exec patch: pre-CreateProcess finalization
Previous Message Tom Lane 2003-12-27 05:11:16 Re: fork/exec patch: pre-CreateProcess finalization