Hannu Krosing <[EMAIL PROTECTED]> writes: > On Thu, 2002-05-02 at 05:33, Tom Lane wrote: >> The temp schema is pg_temp_nnn where nnn is your BackendId (PROC array >> slot number). AFAIK there isn't any exported way to determine your >> BackendId from an SQL query.
> The non-portable way on Linux RH 7.2 : >> create function getpid() returns int as '/lib/libc.so.6','getpid' language 'C'; But PID is not BackendId. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html