Re: \d failing to find uppercased object names

From: Виктор Егоров <vyegorov(at)gmail(dot)com>
To: Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: \d failing to find uppercased object names
Date: 2013-01-24 12:51:46
Message-ID: CAGnEboivieUzPF4C7VbscHWBfGAKC-wWYTf2qCPmSv_MmXp0fA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2013/1/24 Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>:
> 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:
>
> ...
>
> 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.

Take a look at this section in the docs:
http://www.postgresql.org/docs/current/interactive/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS

This is expected behavior.

--
Victor Y. Yegorov

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2013-01-24 13:06:10 Re: pg_ctl idempotent option
Previous Message Nikolay Samokhvalov 2013-01-24 12:46:09 \d failing to find uppercased object names