Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Temporary tables and miscellaneous schemas

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Sean Chittenden <sean(at)chittenden(dot)org>,PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>,btober(at)seaworthysys(dot)com
Subject: Re: [GENERAL] Temporary tables and miscellaneous schemas
Date: 2003-12-22 22:41:54
Message-ID: 18789.1072132914@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> 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

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2003-12-22 22:46:38
Subject: Re: [COMMITTERS] pgsql-server/doc/src/sgml Tag: REL7_4_STABLE r ...
Previous:From: Andrew DunstanDate: 2003-12-22 22:39:49
Subject: Re: TODO list

pgsql-patches by date

Next:From: Tom LaneDate: 2003-12-22 22:50:12
Subject: Re: Doc patch--clarifying $1 in PL/PgSQL
Previous:From: David FetterDate: 2003-12-22 22:08:16
Subject: Doc patch--clarifying $1 in PL/PgSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group