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
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php