Hi again, 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 <[email protected]> wrote: > > > > On Jun 13, 2019, at 13:54, Daniel Cohen <[email protected]> > 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 > [email protected] > >
