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

Re: [GENERAL] how to select temp table

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Robert Gravsjö <robert(at)blogg(dot)se>
Cc: liuzg4 liuzg4 <liuzg4(at)gmail(dot)com>, pgsql-docs(at)postgresql(dot)org
Subject: Re: [GENERAL] how to select temp table
Date: 2009-05-06 19:27:28
Message-ID: 20090506192728.GL4476@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-docspgsql-general
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.

In response to

Responses

pgsql-docs by date

Next:From: David FetterDate: 2009-05-06 19:45:54
Subject: Re: [GENERAL] how to select temp table
Previous:From: Alvaro HerreraDate: 2009-05-06 19:23:54
Subject: Re: how to select temp table

pgsql-general by date

Next:From: Merlin MoncureDate: 2009-05-06 19:39:05
Subject: Re: Postgres partially hang after inactivity
Previous:From: Alvaro HerreraDate: 2009-05-06 19:23:54
Subject: Re: how to select temp table

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