Re: how to select temp table

On 2009-05-06 14.34, liuzg4 liuzg4 wrote:
> ver 8.4
> i create two table with same name  named 'testtable'
>
> one is temp table
>
>
>
>   i select * from testtable
> then this table is a public  or a temp ???

Temp. To access public use "select * from public.testtable".

"Temporary tables exist in a special schema, so a schema name cannot be
given when creating a temporary table."

See http://www.postgresql.org/docs/8.4/static/sql-createtable.html for
details.

/r

> drop table testtable
>
> then is this table a public or a temp? i test ,it drop temp table fisrst!
>
> so am i  must show  public or pg_temp_1  when i has two table with same name
> !!!
>