Re: BUG #5286: pgAdmin will put table and field names in apostrophes which then must be used for accessing them - Mailing list 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