Robert Gravsjö escribió:
> 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.testta
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
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 h
