From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
---|---|
To: | listas(at)guedesoft(dot)net |
Cc: | daniel(at)manitou-mail(dot)org, ishii(at)postgresql(dot)org, robertmhaas(at)gmail(dot)com, pavel(dot)stehule(at)gmail(dot)com, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Why format() adds double quote? |
Date: | 2016-01-27 01:40:57 |
Message-ID: | 20160127.104057.154346136736149633.t-ishii@sraoss.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> Thanks for advocate, I see here that it even produces that output with
> simple spaces.
>
> postgres=# create table x ("aí " text);
> CREATE TABLE
> postgres=# \d x
> Tabela "public.x"
> Coluna | Tipo | Modificadores
> ----------+------+---------------
> aí | text |
>
>
> This will break copy&paste user actions and scripts that parses that output.
>
> Maybe the patch should consider left/right non-printable chars to
> choose whether to show or not the " ?
This is a totally different story from the topic discussed in this
thread. psql never adds double quotations to column name even with
upper case col names.
test=# create table t6("ABC" int);
CREATE TABLE
test=# \d t6
Table "public.t6"
Column | Type | Modifiers
--------+---------+-----------
ABC | integer |
If you want to change the existing psql's behavior, propose it
yourself.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2016-01-27 01:46:23 | Re: Why format() adds double quote? |
Previous Message | Michael Paquier | 2016-01-27 01:31:41 | Re: Speedup twophase transactions |