temp tables

From: "Cima" <ruel(dot)cima(at)facinf(dot)uho(dot)edu(dot)cu>
To: <php-general(at)lists(dot)php(dot)net>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: temp tables
Date: 2005-04-28 04:45:05
Message-ID: 008301c54bad$120d3cd0$d20210ac@khazaddum
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hi,

im working with php 4 and postgresql 8 and in my php script id like to create a temp table on my database server. how do i do this? how do i verify it was created?

i tried the following:

$sql = "create temp table s_info(a int, b text) on commit delete rows ";

pg_query($dbh,$sql);

$dbh is my connection.

any help will be highly appreciated.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Cima 2005-04-28 04:51:59 file oids
Previous Message Joshua D. Drake 2005-04-28 04:13:58 Re: [PHP] temp tables