Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name

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-05-31 03:35:34
Message-ID: 1401507334454-5805646.post@n5.nabble.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgadmin-support

RobR wrote
> I then concluded that the table was being created with the double quotes
> included in the table name.

In short:

log = "log"
Log = "log"
Log = log
LoG = lOg
Log <> "Log"

Again, this is all just parser stuff. Whatever is present post-parse on a
create table is stored, as-is, in the database and then subsequent queries
get parsed and matched literally against what is stored.

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-tp5805606p5805646.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Konstantin Mikhailov 2014-06-01 10:30:05 pgAdmin 1.18.1 (win7) shows dots
Previous Message David G Johnston 2014-05-31 03:27:56 Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name