| From: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name |
| Date: | 2014-06-02 18:09:44 |
| Message-ID: | CAKFQuwZ2rgMo+_4Sixv1FrxRoLvQnb=OFFZmrzhcHhgXbfLsBA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
>
>
> I
> f all the letters are lowercase, no double quotes are added.
>
I don't know if this statement is actually true but it makes no difference
in reality whether the double-quotes are added in the case where only
lowercase letters and numbers/underscore are used. As far the executor is
concerned the same exact identifier text will be used. Likely, and for
reasoning purposes, it is sufficient to consider that ALL identifiers
generated by pgAdmin are surrounded with double-quotes in the resultant SQL
statements that are sent to the server.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/PGAdmin-for-PostgreSQL-9-3-creates-tables-with-double-quotes-embedded-in-the-name-tp5805606p5805784.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Darren Duncan | 2014-06-02 18:15:40 | Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name |
| Previous Message | J.F. Oster | 2014-06-02 17:34:42 | Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name |