Re: Mysterious table that exists but doesn't exist

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Mysterious table that exists but doesn't exist
Date: 2013-04-16 21:01:37
Message-ID: 516DBC31.2050504@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-04-16 21:04:19 Re: Mysterious table that exists but doesn't exist
Previous Message Moshe Jacobson 2013-04-16 20:55:49 Re: Can you spot the difference?