Re: Web Tools

From: jutta staudach <jutta(dot)staudach(at)jez(dot)at>
To: pgsql-questions(at)postgreSQL(dot)org
Subject: Re: Web Tools
Date: 1999-03-23 10:51:34
Message-ID: 36F77236.BD21F37F@jez.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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", \(at)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

Browse pgsql-general by date

  From Date Subject
Next Message Jean Lee 1999-03-23 12:26:11 User authentication failed
Previous Message Hal Snyder 1999-03-23 07:25:44 Re: [GENERAL] Postgresql on sparc