Re: PostgreSQL and HTML output

If you need to dump query result for debugging purpose, etc. Try something like, <?php $db = pg_connect(); $result = pg_query($db, 'SELECT * FROM some_table'); echo "<pre>\n"; var_dump(pg_fetch_all($result)); 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 >