Michael Xu <online....@gmail.com> writes: > By default, pgsql accepts double quotes around schema's name in a query, > e.g. select * from "ads"."MyTableName". In our env, it throws > 42P01:relation "ads.MyTableName" does not exist.
Works for me: regression=# create schema ads; CREATE SCHEMA regression=# create table "ads"."MyTableName" (f1 int); CREATE TABLE regression=# select * from "ads"."MyTableName"; f1 ---- (0 rows) I'm wondering a bit about invisible white space in your schema name; but without a self-contained test case we can do no more than guess. regards, tom lane