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

From: "J(dot)F(dot) Oster" <jinfroster(at)mail(dot)ru>
To: Rob Richardson <RDRichardson(at)rad-con(dot)com>
Cc: 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 17:34:42
Message-ID: 1728555082.20140602213442@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Rob,

Monday, June 2, 2014, 4:43:01 PM, you wrote:

RR> I am not using plain SQL entered manually.═ I am using
RR> PGAdmin's table creation tool.

I'm sure that last week you provided table name in mixed case (more
precisely, with at least one character not in [_a-z0-9]). PgAdmin saw
that and wrapped it in double quotes. If all the letters are
lowercase, no double quotes are added.
By the way, this relates to any identifiers, not only table names.
Isn't that mentioned in PgAdmin help?.. If not, it probably should.

--
Best regards,
J.F.

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message David G Johnston 2014-06-02 18:09:44 Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name
Previous Message Rob Richardson 2014-06-02 12:43:01 Re: PGAdmin for PostgreSQL 9.3 creates tables with double quotes embedded in the name