Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 11.5 \(3445.9.1\))
Subject: Re: Creating dynamically-typed tables using psycopg2's built-in
 formatting
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: 
 <CAHAzoYnrmM2MG8MLzG0mpP-sa0TVPgi1bA9hT0P-JuXRszbuVQ@mail.gmail.com>
Date: Fri, 14 Jun 2019 09:12:10 -0700
Cc: psycopg@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <CEA954F4-E4C3-4427-B85C-616CD11F8D4D@thebuild.com>
References: 
 <CAHAzoYkzXi1HFE0PmY3z0qn4SRnSZLdhChPUePf-2VwTM91upg@mail.gmail.com>
 <33071EF2-86DE-4698-BFAA-6F084024A826@thebuild.com>
 <CAHAzoYnrmM2MG8MLzG0mpP-sa0TVPgi1bA9hT0P-JuXRszbuVQ@mail.gmail.com>
To: Daniel Cohen <daniel.m.cohen@berkeley.edu>
Precedence: bulk


> On Jun 13, 2019, at 13:54, Daniel Cohen <daniel.m.cohen@berkeley.edu> =
wrote:
>=20
> 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).=20

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. =20
--
-- Christophe Pettus
   xof@thebuild.com