In addition to all of the fancy tools, there is the
simple options on psql:
psql -H -c "select * from pg_user;";
This outputs the selections in HTML which I am
not including here. If you also use the -T
option you can set the table attributes.
--elein
elein@varlena.com
=============================================================
elein@varlena.com www.varlena.com
PostgreSQL Consulting & Support
PostgreSQL General Bits http://www.varlena.com/GeneralBits/
=============================================================
I have always depended on the [QA] of strangers.
On Thu, Oct 23, 2003 at 08:38:37PM +0200, Birahim FALL wrote:
> Hi,
>
> I'm very fresh to PostgreSQL, coming from Oracle.
> I want to developp web applications based on apache and postgresql.
> Is there an equivalent of OWA server (Oracle Web Application server) for
> postgresql.
> Shortly, OWA provides an apache module and a set of stored procedures/functions
> that generate html pages.
>
> A simple example could be the following procedure :
>
> procedure hello {
> htp.htmlOpen;
> htp.headOpen;
> htp.title("Simple test page");
> htp.headClose:
> htp.bodyOpen
> htp.print( htf.h2( htf.center( "This is a simple test page" ) ) );
> htp.paragraph;
> htp.print("Dynamic hello from Postgresql");
> htp.bodyClose;
> htp.htmlClose;
> }
>
> That would generate the following html code :
>
> <html>
> <head>
> <title>Simple test page</title>
> </head>
> <body>
> <h2><center>This is a simple test page</center></h2>
> <p></p>
> Dynamic hello from Postgresql
> </body>
> </html>
>
> Is such a product exists (preferably opensource).
> I'm ready to go for python etc, but I really wuld have to re-educate
> myself.....
>
> Thanks in advance.
> Bir
