[Q] EXT SQL IN PostgreSQL
| From: | brown | Date: | Thu, 20 Jun 2002 09:18:04 +0000 |
| Subject: | [Q] EXT SQL IN PostgreSQL | ||
| Groups: | php.qa | ||
| Request: | Send a blank email to php-qa+get-5556@lists.php.net to get a copy of this message | ||
# Sorry to my poor English
I have a procedure ( named by select_table )
##########################################
BEGIN;
select select_table('select_cur','table_name');
FETCH ALL IN select_cur;
COMMIT;
##########################################
This Query is right In Console (psql).
I wanna see a result with php.
$sql = "
BEGIN;
select select_table('select_cur','table_name');
FETCH ALL IN select_cur;
COMMIT;
";
$result = pg_exec($connect,$sql);
$row = pg_fetch_row($result);
is not run.
How can I get the CURSOR from PostgreSQL with PHP ?