--thanks everyone:
--this is what we wound up using:
<excerpt from script>
$tables=`/usr/bin/psql -H -d bcn -U web -c "\\d+"`;
$tables =~ s!(top.+?<td align=left>)(\w+)!$1<a href="$this?t=$2">$2</a>!gsi;
print $tables;
</excerpt>
--going to try yours, too.
--special thanks to sensei in TX for his suggestions (i'll post and
excerpt if i can get his permission)!
thanks again!
-X
-----Original Message-----
From: Micah Yoder
Sent: Monday, October 29, 2001 9:22 PM
To: Shaunn; pgsql-general@postgresql.org
Subject: Re: [GENERAL] psql and HTML
On Monday 29 October 2001 10:40 am, Johnson, Shaunn wrote:
try adding this line (or something similar depending on what your actual link
is):
> $list = `/usr/bin/psql -H -d database -U user -c "\\d+"`;
$list =~ s/(op>\s+<td align=left>)([a-zA-Z0-9_]+)(?=<\/td)/$1<a
href="table.php?name=$2">$2<\/a>/g;
> print $list;
--
Like to travel? http://TravTalk.org
Micah Yoder Internet Development http://yoderdev.com