The following bug has been logged online:
Bug reference: 5286
Logged by: G.Schaeffler
Email address: scgn@sie.at
PostgreSQL version: 8.4.2
Operating system: windows server 2003 std
Description: pgAdmin will put table and field names in apostrophes
which then must be used for accessing them
Details:
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.
ie.
SELECT * from t_test; will return ERROR: Relation t_test does not exit
SELECT val from "t_test" will return ERROR: field val does not exist.
when using the following sql statement
select * from information_schema.tables where table_schema='public' and
table_type='BASE TABLE'
to get the tablename as it is saved in the db, it will return t_test, not
"t_test" though.