On Fri, Jun 14, 2019 at 6:44 PM Sebastiaan Mannem < sebastiaan.man...@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
