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: (view raw, whole thread or download thread mbox)
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
      print $tables;

--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!


-----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

> $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 

> print $list;

Like to travel?              
Micah Yoder Internet Development

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-2017 The PostgreSQL Global Development Group