| From: | elein <elein(at)varlena(dot)com> |
|---|---|
| To: | Birahim FALL <birahim(dot)fall(at)hispeed(dot)ch> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: HTML generation with PL/PgSQL |
| Date: | 2003-10-26 00:27:23 |
| Message-ID: | 20031025172723.A16637@cookie.varlena.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)varlena(dot)com
=============================================================
elein(at)varlena(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John DeSoi | 2003-10-26 01:01:13 | Re: shared memory on OS X - 7.4beta4 |
| Previous Message | Yonatan Goraly | 2003-10-25 22:26:22 | Re: Slow performance with no apparent reason |