Re: PostgreSQL table list help!!!
| From: | Doug Semig | Date: | Wed, 14 Jun 2000 19:53:50 +0000 |
| Subject: | Re: PostgreSQL table list help!!! | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-414@lists.php.net to get a copy of this message | ||
Hi Brian--
How about just connecting to the database with a pg_connect (or
pg_pconnect) and then executing some SQL such as:
SELECT datname, datdba, encoding, datpath FROM pg_database;
Then you can loop through the result set and put anchor tags around them.
Doug
Brian C. Doyle was heard at 01:17 PM 6/13/00 -0400 to say:
>Hello all,
>
>I have a page that is running;
><?
>$i=passthru("psql -H -l");
>echo $i;
>?>
>
>and I am getting a really nice table of my databases, which I do want. The
>problem is that I want to be able to each database title a link to another
>page.
>
>I have tried
><?
>$i=exec("psql -H -l");
>echo $i[#];
>?>
>
>and all i get if i put enough of the array variables in is </table>
>
>Please any help would be greatly appreciated.
>
>Brian C. Doyle
>Coach Team Force
>Earthlink Mindspring Technical Support
>support@mindspring.com
>