Re: Web Tools - Mailing list pgsql-general

From jutta staudach
Subject Re: Web Tools
Date
Msg-id 36F77236.BD21F37F@jez.at
Whole thread Raw
In response to Web Tools  ("Ronald L. Chichester" <complaw@hal-pc.org>)
List pgsql-general
I found no examples, but a very good description in the Pg.pm file
here is a example for a local database:
#!/usr/bin/perl
print "Content-type: text/html", "\r\n\r\n";
print "<HTML>", "\n";
print "<HEAD><TITLE></TITLE></HEAD>","\n";
print "<body bgcolor=#FFFFFF link='#0000FF'vlink='#800080'>","\n";
print "<BODY>", "\n";
require Pg;
$conn = Pg::connectdb("dbname=postgres");

   Pg::doQuery($conn, "select * from probe", \@ary);

    for $i ( 0 .. $#ary ) {
        for $j ( 0 .. $#{$ary[$i]} ) {
            print "$ary[$i][$j]\t";
        }
        print "\n";
    }
print "</BODY></HTML>", "\n";
exit(0);
Ciao Jutta
Ronald L. Chichester schrieb:

> Hi:
>
> I want to use PostgreSQL as a database engine for a web-based intranet
> (using Apache on Linux).  Is there a repository of CGI examples that I
> could use, or are there some software tools that could take out some of
> the time and grunt work?
>
> Thanks in advance,
>
> Ron Chichester


pgsql-general by date:

Previous
From: Hal Snyder
Date:
Subject: Re: [GENERAL] Postgresql on sparc
Next
From: Jean Lee
Date:
Subject: User authentication failed