My php code is creating temporary table named mytemp,but when I run a selec * from mytemp I cannot see the table.How can I see the table from postgresql command prompt? ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend