On Thursday 21 February 2008 00:17:56 Chris wrote:
> 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 :)
Temp tables are also limited in scope to the current session, so if your PHP
process created the temp table, then ONLY your PHP process can see the temp
table (and even then only until a dis-connect occurs)
