From: | "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net> |
---|---|
To: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
Cc: | Daniel Verite <daniel(at)manitou-mail(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Pavel Stěhule <pavel(dot)stehule(at)gmail(dot)com>, pg-dev <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Why format() adds double quote? |
Date: | 2016-01-27 22:47:00 |
Message-ID: | CAHHcrerFYPB0+4p3H3hvt8O-HwNYkAaY+bcxyx6PQ4tfm1snnA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
2016-01-26 23:40 GMT-02:00 Tatsuo Ishii <ishii(at)postgresql(dot)org>:
>> 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.
Indeed, you are right.
> If you want to change the existing psql's behavior, propose it
> yourself.
It could be interesting, maybe using a \pset quote_columns_char, I'll
think about, thank you.
Best regards.
--
Dickson S. Guedes
mail/xmpp: guedes(at)guedesoft(dot)net - skype: guediz
http://github.com/guedes - http://guedesoft.net
http://www.postgresql.org.br
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2016-01-28 00:00:29 | Re: Why format() adds double quote? |
Previous Message | Fabien COELHO | 2016-01-27 22:43:34 | Re: extend pgbench expressions with functions |