Re: How to view temp tables

From: Chris <dmagick(at)gmail(dot)com>
To: pc <chavanpriya(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to view temp tables
Date: 2008-02-21 07:17:56
Message-ID: 47BD25A4.6040205@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-02-21 07:23:31 Re: How to make update rapidly?
Previous Message hewei 2008-02-21 07:07:00 Re: How to make update rapidly?