Re: [GENERAL] how to select temp table - Mailing list pgsql-docs

From Alvaro Herrera
Subject Re: [GENERAL] how to select temp table
Date
Msg-id 20090506192728.GL4476@alvh.no-ip.org
Whole thread Raw
Responses Re: [GENERAL] how to select temp table
Re: [GENERAL] how to select temp table
List pgsql-docs
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.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: doc bug: SELECT SUBSTRING example is missing keyword FROM
Next
From: David Fetter
Date:
Subject: Re: [GENERAL] how to select temp table