Re: [PHP] temp tables

Cima wrote:
> 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?
>

Well if the creation fails pg_query will throw an error. However temp
tables are only good for the life of the connection (script in this
case). You will probably want to consider that.

Sincerely,

Joshua D. Drake

> 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.

--
Your PostgreSQL solutions provider, Command Prompt, Inc.
24x7 support - 1.800.492.2240, programming, and consulting
Home of PostgreSQL Replicator, plPHP, plPerlNG and pgPHPToolkit
http://www.commandprompt.com / http://www.postgresql.org