From: | John DeSoi <desoi(at)pgedit(dot)com> |
---|---|
To: | "Cima" <ruel(dot)cima(at)facinf(dot)uho(dot)edu(dot)cu> |
Cc: | PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: temp tables |
Date: | 2005-04-28 12:18:19 |
Message-ID: | 9B15E96C-B7DF-11D9-A5B4-000A95B03262@pgedit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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 ";
>
> pg_query($dbh,$sql);
>
>
> $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.
http://pgedit.com/
Power Tools for PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | andras-list | 2005-04-28 12:55:43 | pg8.0.2 win install |
Previous Message | Jessica Ditt | 2005-04-28 12:11:29 | Problem with DirectFunctionCall3(array_in,...) |