Konstantin Izmailov <pgf...@gmail.com> writes: > My application creates/uses a temporary table "X" via multiple > connections at the same time. Is there a way to determine which > pg_temp_N belongs to the current connection?
It seems unlikely that you need to determine that explicitly to solve your problem. Just use WHERE C.oid = 'X'::regclass to constrain the pg_class query, and forget matching to the schema name at all. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general