pc wrote:
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?
temp tables are automatically deleted when the connection is closed. make it a non-temp table :) -- Postgresql & php tutorials http://www.designmagick.com/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend