Date: Wed, 6 May 2009 16:58:38 -0400
From: Alvaro Herrera <alvherre@commandprompt.com>
To: David Fetter <david@fetter.org>
Cc: Robert =?iso-8859-1?Q?Gravsj=F6?= <robert@blogg.se>,
	liuzg4 liuzg4 <liuzg4@gmail.com>, pgsql-docs@postgresql.org
Subject: Re: [GENERAL] how to select temp table
Message-ID: <20090506205838.GN4476@alvh.no-ip.org>
References: <f97af4400905060534y6312540aqf9ad2c09b0905472@mail.gmail.com>
	<4A01CFE8.9010005@blogg.se> <20090506192354.GK4476@alvh.no-ip.org>
	<20090506192728.GL4476@alvh.no-ip.org>
	<20090506194554.GY20491@fetter.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <20090506194554.GY20491@fetter.org>
User-Agent: Mutt/1.5.18 (2008-05-17)

David Fetter escribió:
> On Wed, May 06, 2009 at 03:27:28PM -0400, Alvaro Herrera wrote:
> > Alvaro Herrera escribió:
> > 
> > > Note that you can refer to the temp table like this:
> > > 
> > > select * from pg_temp.testtable;
> > 
> > BTW I found no mention of pg_temp in the doc page here:
> > http://www.postgresql.org/docs/current/static/ddl-schemas.html
> > 
> > Apparently the only mention of pg_temp is in the CREATE FUNCTION page.
> 
> That's probably not a good omission.  Any ideas as to where further
> mentions should go?

I think mentioning it in the page I link to above would be good.  I
can't think of any further places on which it should be mentioned.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support