Skip site navigation (1) Skip section navigation (2)

Re: BUG #5286: pgAdmin will put table and field names in apostrophes which then must be used for accessing them

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: "G(dot)Schaeffler" <scgn(at)sie(dot)at>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5286: pgAdmin will put table and field names in apostrophes which then must be used for accessing them
Date: 2010-01-18 20:38:20
Message-ID: 20100118203820.GD3617@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-bugs
G.Schaeffler wrote:

> if i create a table by using the pgadmin gui, it will create statements
> like
> CREATE TABLE "t_test" (
> id integer,
> "val" character varying(1000) NOT NULL ); 
> after creation, i can only access the table again if i wrap the apostrophes
> around the table and field names as in the create table statement.

Does your table name have uppercase chars?  If it has, that's probably
the reason the name doesn't work unless quoted.  This is expected
behavior for identifiers.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

pgsql-bugs by date

Next:From: Brian CarpDate: 2010-01-18 21:02:50
Subject: BUG #5287: ispell dict erroneously returns lexeme on all prefix+suffix cross products
Previous:From: Robert HaasDate: 2010-01-18 20:33:02
Subject: Re: BUG #5284: Postgres CPU 100% and worker took too long to start; cancelled... Systemdown

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group