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