Thread: How to view temp tables

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?

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/

On Wed, Feb 20, 2008 at 7:30 PM, pc <chavanpriya@gmail.com> 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?

Got a code sample that shows this problem?  I.e. create table
statement, php script that tries to hit it.  Error codes are nice too.

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)