Postgres Pro
Downloads
Home   >   mailing lists

Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name - Mailing list pgadmin-support

From David G Johnston
Subject Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name
Date
Msg-id CAKFQuwZ2rgMo+_4Sixv1FrxRoLvQnb=OFFZmrzhcHhgXbfLsBA@mail.gmail.com
Whole thread Raw
In response to Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name  ("J.F. Oster" <jinfroster@mail.ru>)
Responses Re: Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name  (Dave Page <dpage@pgadmin.org>)
List pgadmin-support
Tree view

​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: Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

pgadmin-support by date:

Previous
From: Darren Duncan
Date:
Subject: Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name
Next
From: Dave Page
Date:
Subject: Re: Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name