public inbox for [email protected]  

help / color / mirror / Atom feed
From: Daniel Cohen <[email protected]>
To: Daniele Varrazzo <[email protected]>
Cc: Christophe Pettus <[email protected]>
Cc: Sebastiaan Mannem <[email protected]>
Cc: [email protected]
Subject: Re: Creating dynamically-typed tables using psycopg2's built-in formatting
Date: Fri, 14 Jun 2019 13:41:02 -0700
Message-ID: <CAHAzoY=gFqbUNVP0zunM3g++yOSOTRJ01Zo_B9k+9g702iLOLA@mail.gmail.com> (raw)
In-Reply-To: <CA+mi_8aMcR3uhZHjdDkWfx_zJ9NgnHL9U_injEjg62wA5+7YUg@mail.gmail.com>
References: <CAHAzoYkzXi1HFE0PmY3z0qn4SRnSZLdhChPUePf-2VwTM91upg@mail.gmail.com>
	<[email protected]>
	<CAHAzoYnrmM2MG8MLzG0mpP-sa0TVPgi1bA9hT0P-JuXRszbuVQ@mail.gmail.com>
	<[email protected]>
	<CAHAzoYn6a73nb_cZ-vuFiq=x0bTPyYYu9CyWmXFiLEtuhM2JTg@mail.gmail.com>
	<[email protected]>
	<CA+mi_8aMcR3uhZHjdDkWfx_zJ9NgnHL9U_injEjg62wA5+7YUg@mail.gmail.com>

Awesome, thanks!

On Fri, Jun 14, 2019 at 12:13 PM Daniele Varrazzo <
[email protected]> wrote:

> On Fri, Jun 14, 2019 at 6:44 PM Sebastiaan Mannem <
> [email protected]> 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
>


view thread (13+ messages)

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Creating dynamically-typed tables using psycopg2's built-in formatting
  In-Reply-To: <CAHAzoY=gFqbUNVP0zunM3g++yOSOTRJ01Zo_B9k+9g702iLOLA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox