If you need to dump query result for debugging purpose, etc.
Try something like,


$db = pg_connect();
$result = pg_query($db, 'SELECT * FROM some_table');

echo "<pre>\n";
echo "</pre>\n";


You need PHP 4.3.0-dev or later for pg_fetch_all().

Yasuo Ohgaki

Yasuo Ohgaki wrote:
> Edwin Robertson wrote:
>>With psql you can get all your output in HTML format.  Anyone know of a way
>>to do this in PHP?
> It's psql feature and there is no automatic HTML format
> in PHP's pgsql module.
> If really would like, you can use passthru() and psql.
> <?php
> passthru('/usr/local/pgsql/bin/psql -f select.sql -H -U yohgaki -d test');
> ?>
> where "select.sql" is query you need.
> --
> Yasuo Ohgaki

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to