Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Is current_schemas(true)) 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))) ...
would probably work well enough.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2003-12-22 22:46:38|
|Subject: Re: [COMMITTERS] pgsql-server/doc/src/sgml Tag: REL7_4_STABLE r ... |
|Previous:||From: Andrew Dunstan||Date: 2003-12-22 22:39:49|
|Subject: Re: TODO list|
pgsql-patches by date
|Next:||From: Tom Lane||Date: 2003-12-22 22:50:12|
|Subject: Re: Doc patch--clarifying $1 in PL/PgSQL |
|Previous:||From: David Fetter||Date: 2003-12-22 22:08:16|
|Subject: Doc patch--clarifying $1 in PL/PgSQL|