MIME-Version: 1.0
References: 
 <CAHAzoYkzXi1HFE0PmY3z0qn4SRnSZLdhChPUePf-2VwTM91upg@mail.gmail.com>
 <33071EF2-86DE-4698-BFAA-6F084024A826@thebuild.com>
 <CAHAzoYnrmM2MG8MLzG0mpP-sa0TVPgi1bA9hT0P-JuXRszbuVQ@mail.gmail.com>
 <CEA954F4-E4C3-4427-B85C-616CD11F8D4D@thebuild.com>
In-Reply-To: <CEA954F4-E4C3-4427-B85C-616CD11F8D4D@thebuild.com>
From: Daniel Cohen <daniel.m.cohen@berkeley.edu>
Date: Fri, 14 Jun 2019 09:41:28 -0700
Message-ID: 
 <CAHAzoYn6a73nb_cZ-vuFiq=x0bTPyYYu9CyWmXFiLEtuhM2JTg@mail.gmail.com>
Subject: Re: Creating dynamically-typed tables using psycopg2's built-in
 formatting
To: Christophe Pettus <xof@thebuild.com>
Cc: psycopg@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000125b96058b4b5287"
Precedence: bulk

--000000000000125b96058b4b5287
Content-Type: text/plain; charset="UTF-8"

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 <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
>
>

--000000000000125b96058b4b5287
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi again,</div><div><br></div><div>I realize the erro=
r was that I specified the name as &quot;schema.tbl&quot;, and I think beca=
use there was a period in the name, it converted to double-quote. I tried a=
gain as just &quot;tbl&quot; and it worked perfectly. Thanks so much for al=
l your help.</div><div><br></div><div>Best,</div><div><br></div><div>Danny =
<br></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gm=
ail_attr">On Fri, Jun 14, 2019 at 9:12 AM Christophe Pettus &lt;<a href=3D"=
mailto:xof@thebuild.com">xof@thebuild.com</a>&gt; wrote:<br></div><blockquo=
te class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px =
solid rgb(204,204,204);padding-left:1ex"><br>
<br>
&gt; On Jun 13, 2019, at 13:54, Daniel Cohen &lt;<a href=3D"mailto:daniel.m=
.cohen@berkeley.edu" target=3D"_blank">daniel.m.cohen@berkeley.edu</a>&gt; =
wrote:<br>
&gt; <br>
&gt; Thanks so much for your response. The uppercase --&gt; lowercase fix w=
orked for the types, but I&#39;m still only getting tables that can be sear=
ched by double-quotations (i.e. &gt; SELECT * FROM tbl; returns nothing, bu=
t &gt; SELECT * FROM &quot;tbl&quot;; returns the table I uploaded). <br>
<br>
By &quot;returns nothing,&quot; do you mean you get an error, or that you g=
et zero rows?<br>
<br>
I&#39;d connect to the database using psql and use \d to see what tables ac=
tually exist.=C2=A0 <br>
--<br>
-- Christophe Pettus<br>
=C2=A0 =C2=A0<a href=3D"mailto:xof@thebuild.com" target=3D"_blank">xof@theb=
uild.com</a><br>
<br>
</blockquote></div>

--000000000000125b96058b4b5287--