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>
 <CAHAzoYn6a73nb_cZ-vuFiq=x0bTPyYYu9CyWmXFiLEtuhM2JTg@mail.gmail.com>
 <575FDD0B-5C9C-42D5-BAF5-FA898E6A9B3B@enterprisedb.com>
 <CA+mi_8aMcR3uhZHjdDkWfx_zJ9NgnHL9U_injEjg62wA5+7YUg@mail.gmail.com>
In-Reply-To: 
 <CA+mi_8aMcR3uhZHjdDkWfx_zJ9NgnHL9U_injEjg62wA5+7YUg@mail.gmail.com>
From: Daniel Cohen <daniel.m.cohen@berkeley.edu>
Date: Fri, 14 Jun 2019 13:41:02 -0700
Message-ID: 
 <CAHAzoY=gFqbUNVP0zunM3g++yOSOTRJ01Zo_B9k+9g702iLOLA@mail.gmail.com>
Subject: Re: Creating dynamically-typed tables using psycopg2's built-in
 formatting
To: Daniele Varrazzo <daniele.varrazzo@gmail.com>
Cc: Christophe Pettus <xof@thebuild.com>,
	Sebastiaan Mannem <sebastiaan.mannem@enterprisedb.com>,
 psycopg@postgresql.org
Content-Type: multipart/alternative; boundary="000000000000d69932058b4eaa05"
Precedence: bulk

--000000000000d69932058b4eaa05
Content-Type: text/plain; charset="UTF-8"

Awesome, thanks!

On Fri, Jun 14, 2019 at 12:13 PM Daniele Varrazzo <
daniele.varrazzo@gmail.com> wrote:

> On Fri, Jun 14, 2019 at 6:44 PM Sebastiaan Mannem <
> sebastiaan.mannem@enterprisedb.com> wrote:
>
>> Yeah,
>> "schema.tbl" will search all schemas in search path for a table
>> explicitly called "schema.tbl".
>> So that will never find a table called "tbl", and most probably never
>> find a table at all.
>>
>
> Also note that from psycopg 2.8 you can use Identifier("schema", "tbl") to
> represent a dot-separated sequence of identifiers.
>
> http://initd.org/psycopg/docs/sql.html#psycopg2.sql.Identifier
>
>
> -- Daniele
>

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

<div>Awesome, thanks!</div><div><br><div class=3D"gmail_quote"><div dir=3D"=
ltr" class=3D"gmail_attr">On Fri, Jun 14, 2019 at 12:13 PM Daniele Varrazzo=
 &lt;<a href=3D"mailto:daniele.varrazzo@gmail.com">daniele.varrazzo@gmail.c=
om</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margi=
n:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr">=
<div dir=3D"ltr">On Fri, Jun 14, 2019 at 6:44 PM Sebastiaan Mannem &lt;<a h=
ref=3D"mailto:sebastiaan.mannem@enterprisedb.com" target=3D"_blank">sebasti=
aan.mannem@enterprisedb.com</a>&gt; wrote:<br></div><div class=3D"gmail_quo=
te"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bor=
der-left:1px solid rgb(204,204,204);padding-left:1ex"><div>Yeah,<div>&quot;=
schema.tbl&quot; will search all schemas in search path for a table explici=
tly called &quot;schema.tbl&quot;.</div><div>So that will never find a tabl=
e called &quot;tbl&quot;, and most probably never find a table at all.</div=
></div></blockquote><div><br></div><div>Also note that from psycopg 2.8 you=
 can use Identifier(&quot;schema&quot;, &quot;tbl&quot;) to represent a dot=
-separated sequence of identifiers.</div><div><br></div><div><a href=3D"htt=
p://initd.org/psycopg/docs/sql.html#psycopg2.sql.Identifier" target=3D"_bla=
nk">http://initd.org/psycopg/docs/sql.html#psycopg2.sql.Identifier</a></div=
></div></div><div dir=3D"ltr"><div class=3D"gmail_quote"><div><br></div><di=
v><br></div><div>-- Daniele</div></div></div>
</blockquote></div></div>

--000000000000d69932058b4eaa05--