On Apr 28, 2005, at 12:45 AM, Cima wrote:
> 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 ";
> $dbh is my connection.
> any help will be highly appreciated.
You can verify it was created by checking the result from pg_query and
looking at pg_last_error. The table is automatically dropped at the end
of the connection, most likely when your PHP script ends.
John DeSoi, Ph.D.
Power Tools for PostgreSQL
In response to
pgsql-novice by date
|Next:||From: andras-list||Date: 2005-04-28 12:55:43|
|Subject: pg8.0.2 win install|
|Previous:||From: Jessica Ditt||Date: 2005-04-28 12:11:29|
|Subject: Problem with DirectFunctionCall3(array_in,...)|