Hello,
some app created tables ussing uppercase letters in table names (this app was migrated from mysql). One tries to use \d to search tables info:
ru=# \d pnct_Board
Did not find any relation named "pnct_Board".
Of course, it works with ":
ru=# \d "pnct_Board"
Table "public.pnct_Board"
Column | Type | Modifiers
-------------+----------+-----------------------------------------------------------
id | bigint | not null default nextval('"pnct_Board_id_seq"'::regclass)
<...>
Could this be considered as gotcha?
The thing is that Postgres reply is pretty much clear:
> Did not find any relation named "pnct_Board".
, but table "pnct_Board" does exist in the system, so Postgres' reply is obviously incorrect.
Version: 9.2.1