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])