Re: Creating dynamically-typed tables using psycopg2's built-in formatting

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