Re: psql and HTML

--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(at)postgresql(dot)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