Re: Mysterious table that exists but doesn't exist - Mailing list pgsql-general

From John R Pierce
Subject Re: Mysterious table that exists but doesn't exist
Date
Msg-id 516DBC31.2050504@hogranch.com
Whole thread Raw
In response to Re: Mysterious table that exists but doesn't exist  (Dale Fukami <dale.fukami@gmail.com>)
List pgsql-general
On 4/16/2013 1:48 PM, Dale Fukami wrote:
> Tried the select with the quotes around each of the schema and table
> and I get the same result ("someschema"."tracked_deductibles"). I'm
> pretty certain they're both lowercase. Would the select from pg_tables
> show if they were mixed case by accident?
>

yes, it would.      I was assuming "someschema" was a made-up name to
hide some business secrets.


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



pgsql-general by date:

Previous
From: Moshe Jacobson
Date:
Subject: Re: Can you spot the difference?
Next
From: Tom Lane
Date:
Subject: Re: Mysterious table that exists but doesn't exist