Skip site navigation (1) Skip section navigation (2)

Re: psql and HTML

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: psql and HTML
Date: 2001-10-30 13:21:41
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB03FFFF45@snt452.corp.bcbsm.com (view raw or flat)
Thread:
Lists: pgsql-general
--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

pgsql-general by date

Next:From: Jean-Michel POUREDate: 2001-10-30 13:28:40
Subject: Re: [HACKERS] Serious performance problem
Previous:From: Paul TomblinDate: 2001-10-30 13:21:15
Subject: Re: Differential Backups

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group