Re: [Q] EXT SQL IN PostgreSQL

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 ?