Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 140AC632FB7 for ; Wed, 6 May 2009 16:45:58 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 27714-09 for ; Wed, 6 May 2009 16:45:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from fetter.org (start.fetter.org [66.92.188.65]) by mail.postgresql.org (Postfix) with ESMTP id 1519D632C85 for ; Wed, 6 May 2009 16:45:56 -0300 (ADT) Received: by fetter.org (Postfix, from userid 500) id B1003FBCBC9; Wed, 6 May 2009 12:45:54 -0700 (PDT) Date: Wed, 6 May 2009 12:45:54 -0700 From: David Fetter To: Alvaro Herrera Cc: Robert =?iso-8859-1?Q?Gravsj=F6?= , liuzg4 liuzg4 , pgsql-docs@postgresql.org Subject: Re: [GENERAL] how to select temp table Message-ID: <20090506194554.GY20491@fetter.org> References: <4A01CFE8.9010005@blogg.se> <20090506192354.GK4476@alvh.no-ip.org> <20090506192728.GL4476@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20090506192728.GL4476@alvh.no-ip.org> User-Agent: Mutt/1.5.18 (2008-05-17) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200905/2 X-Sequence-Number: 5163 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? Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate