If I create a global and local temp with the same name, when I query the table name I get the local temp table.
Code: Select all
dbadmin=> create global temp table temp_table (g_a int);
CREATE TABLE
dbadmin=> create local temp table temp_table (l_a int);
CREATE TABLE
dbadmin=> select * from temp_table;
l_a
-----
(0 rows)