how to select temp table

From: liuzg4 liuzg4 <liuzg4(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to select temp table
Date: 2009-05-06 12:34:25
Message-ID: f97af4400905060534y6312540aqf9ad2c09b0905472@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

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 ???
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
!!!

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Robert Gravsjö 2009-05-06 17:59:04 Re: how to select temp table
Previous Message Tom Lane 2009-04-28 21:46:46 Re: doc bug: SELECT SUBSTRING example is missing keyword FROM

Browse pgsql-general by date

  From Date Subject
Next Message durumdara 2009-05-06 12:35:47 Re: Transaction settings: nowait
Previous Message ml 2009-05-06 12:31:15 tsearch2 memory problem