Re: Output HTML, or just a handle? - Mailing list pgsql-novice

From Alexander Borkowski
Subject Re: Output HTML, or just a handle?
Date
Msg-id 41F5B0BF.1050102@abri.une.edu.au
Whole thread Raw
In response to Output HTML, or just a handle?  ("Rodolfo J. Paiz" <rpaiz@simpaticus.com>)
List pgsql-novice
Rodolfo,

> Looking for "best practices" here. I've just seen that psql can output a
> query to an HTML file. [...] Or is it recommended to just run the bare query, then use PHP on my
> webpage to loop through the resulting output table handle and create the
> table there? [...]

Depends on your application really and without more information there is
  nothing else I can say. For the vast majority of scenarios you
probably are better off using PHP (or some other language like Python,
Perl, Java, C, ...) and just loop through the result set. For PHP have a
look at

http://www.php.net/manual/en/ref.pgsql.php

Cheers,

Alex

pgsql-novice by date:

Previous
From: Ramon Orticio
Date:
Subject: recommended programming language for postgresql
Next
From: Alexander Borkowski
Date:
Subject: Re: SQL and function reference?