Postgres Pro
Downloads
Home   >   mailing lists

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

From Daniele Varrazzo
Subject Re: Creating dynamically-typed tables using psycopg2's built-in formatting
Date
Msg-id CA+mi_8aMcR3uhZHjdDkWfx_zJ9NgnHL9U_injEjg62wA5+7YUg@mail.gmail.com
Whole thread Raw
In response to Re: Creating dynamically-typed tables using psycopg2's built-in formatting  (Sebastiaan Mannem <sebastiaan.mannem@enterprisedb.com>)
Responses Re: Creating dynamically-typed tables using psycopg2's built-in formatting  (Daniel Cohen <daniel.m.cohen@berkeley.edu>)
List psycopg
Tree view
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.


-- Daniele
Attachment

psycopg by date:

Previous
From: Sebastiaan Mannem
Date:
Subject: Re: Creating dynamically-typed tables using psycopg2's built-in formatting
Next
From: Daniel Cohen
Date:
Subject: Re: Creating dynamically-typed tables using psycopg2's built-in formatting