[SQL] prob with PERL/Postgres

[Kristopher Yates]

PERL SNIPPET:

# build arrays from file (OMITTED)

use Pg;
$dbhost='127.0.0.1';
$dbname='mpact';
#$connstr="dbname=$dbname";
$connstr="host=$dbhost dbname=$dbname";
$conn = Pg::connectdb($connstr);

#more code related to date omitted

$result=$conn->exec($sql);
(PGRES_COMMAND_OK eq $result->resultStatus)
or  die $conn->errorMessage;

WHY DO I GET PQsendQuery() -- There is no connection to the 
backend.  I have tried leaving host blank, using IP 127.0.0.1 and 
hostname localhost.  This script should work - the problem is 
something with postgres but I dont know what.  Any ideas out 
there?  Thanks,  Kris

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[SQL] unsubscribe

[Kristopher Yates]

unsubscribe


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Re: [SQL] SQL to list databases?

[Kristopher Yates]

I have been wondering the same thing..  

Thanks

Kris

Ben Siders wrote:


Is there a query that will return all the databases available, similar 
to what psql -l does?



---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

.





---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster