PostgreSQL module does not have cursor. All you have to do is execute query then fetch records one by one. For example,
$result = pg_query($db_connection, 'select * from your_table;'); while ($record = pg_fetch_array($result)) { print_r($record); } Above code can be used to print all records in a result set. -- Yasuo Ohgaki Brown wrote: > # 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 ? > > > > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php