Bruce Momjian <[EMAIL PROTECTED]> writes:
> Is current_schemas(true))[1] always the temp schema name?

If you have a temp schema; otherwise it'll be whatever is the front of
your search path.

> That would clean things up nicely.

If you're intent on doing this in \dn, something like

... AND (nspname not like 'pg\\_temp%'
         OR nspname = (current_schemas(true))[1]) ...

would probably work well enough.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to