Re: Quoting of psql \d output

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Quoting of psql \d output
Date: 2003-12-23 05:27:30
Message-ID: 645.1072157250@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> psql \d always double-quotes table names:
> Table "public.xx"

Yeah, that has bugged me for a while, because it is in fact *wrong* ...
the above representation of a qualified name is incorrect.

> This patch uses pg_dump fmtId() to double-quote only when necessary.

Seems good, but I think your Makefile patch is a brick or two shy of
a load. Don't you need something to make sure that parser/keywords.o
is up to date?

More generally, maybe we ought to think about moving fmtId() and perhaps
other parts of dumputils out of pg_dump and into some
more-easily-accessible library.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2003-12-23 13:04:06 Re: Quoting of psql \d output
Previous Message Bruce Momjian 2003-12-23 05:09:53 Quoting of psql \d output

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2003-12-23 13:04:06 Re: Quoting of psql \d output
Previous Message Bruce Momjian 2003-12-23 05:09:53 Quoting of psql \d output