Postgres Pro
Downloads
Home   >   mailing lists

how to select temp table - Mailing list pgsql-general

From liuzg4 liuzg4
Subject how to select temp table
Date
Msg-id f97af4400905060534y6312540aqf9ad2c09b0905472@mail.gmail.com
Whole thread Raw
Responses Re: how to select temp table  (Robert Gravsjö <robert@blogg.se>)
List pgsql-general
Tree view
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 !!!
 

pgsql-general by date:

Previous
From: Joao Ferreira
Date:
Subject: Re: XML -> PG ?
Next
From: "Slansky Lukas"
Date:
Subject: Re: PGSQL x iptables