The following bug has been logged online: Bug reference: 5286 Logged by: G.Schaeffler Email address: s...@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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
