I realize the error was that I specified the name as "schema.tbl", and I think because there was a period in the name, it converted to double-quote. I tried again as just "tbl" and it worked perfectly. Thanks so much for all your help.
Best,
Danny
On Fri, Jun 14, 2019 at 9:12 AM Christophe Pettus <xof@thebuild.com> wrote:
> On Jun 13, 2019, at 13:54, Daniel Cohen <daniel.m.cohen@berkeley.edu> wrote: > > Thanks so much for your response. The uppercase --> lowercase fix worked for the types, but I'm still only getting tables that can be searched by double-quotations (i.e. > SELECT * FROM tbl; returns nothing, but > SELECT * FROM "tbl"; returns the table I uploaded).
By "returns nothing," do you mean you get an error, or that you get zero rows?
I'd connect to the database using psql and use \d to see what tables actually exist. -- -- Christophe Pettus xof@thebuild.com