psql and HTML

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: psql and HTML
Date: 2001-10-29 15:40:37
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB03FFFF42@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Howdy:

Running postgres 7 on Linux server (Mandrake 8) and
I'm trying to create a dynamic HTML page with the
list of tables I have.

If I do something like this in a perl script:

[snip]

$list = `/usr/bin/psql -H -d database -U user -c "\\d+"`;
print $list;

[/snip]

I get a page with the list of tables, no problem.
What I WANT to do is modify the HTML tags so that
each table in the list is highlighted and is an anchored
reference to someplace else. (That someplace else will
be another page giving the user some background info
on the table, the owner, the description, what it's
used for, etc).

I'm thinking that there is a way to modify it (or at least,
try to substitute what postgres creates, modify the HTML
part and input the list of tables again) via postgres,
but I'm not sure.

Has anyone done something like that? Are there any HTML
examples via postgres?

TIA

-X

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Hallam 2001-10-29 16:13:19 PsqlODBC and SQLDescribeCol
Previous Message Sheer El-Showk 2001-10-29 15:11:33 Re: concurrency performance degradation