Re: [GENERAL] How to view temp tables

2008-02-21 Thread Kevin Kempter
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 conn

Re: [GENERAL] How to view temp tables

2008-02-20 Thread Scott Marlowe
On Wed, Feb 20, 2008 at 7:30 PM, pc <[EMAIL PROTECTED]> 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 ta

Re: [GENERAL] How to view temp tables

2008-02-20 Thread Chris
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 & p

[GENERAL] How to view temp tables

2008-02-20 Thread pc
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