Uppercase names

[lib]

Uppercase names

[fdr]

The problem is probably a need or double-quoting. By default PostgreSQL will case fold identifiers:

fdr=> create temporary table HeLlO(a int);
CREATE TABLE
fdr=> insert into hello values (1);
INSERT 0 1

However, if double quoted, the cases are preserved, and note that an unquoted case rendition will not work, and has its identifier case folded:

fdr=> create temporary table "HeLlO"(a int)
fdr=> insert into HeLlO values (1);
ERROR:  relation "hello" does not exist
LINE 1: insert into HeLlO values (1);

The solution is to double quote the identifier in your query:

fdr=> insert into "HeLlO" values (1);
INSERT 0 1

Since pq is pretty much unaware (to wit) of schema objects and just concerns itself with monolithic query text, I don't think this is a bug for pq unless I am forgetting something.