Konstantin Izmailov <pgfizm@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
