Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group