Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: PGSQL / DBI

by Ranna (Acolyte)
on Mar 19, 2001 at 08:07 UTC ( #65356=note: print w/replies, xml ) Need Help??


in reply to PGSQL / DBI

Yeah, sorry for this not being a perl post, but I couldn't get anyone to help me anywhere else :o\

Anyways, thanks for the link to the documentation, I'll look into it.

Here's the error message I'm getting, even after I changed the name of the table to rfpusers: psql:rfp.sql:9: ERROR:  parser: parse error at or near "(" Which is bio       VARCHAR(75)  NULL ); I dunno if that helps any...

Oops, I forgot to include the reason I have DBI in the title; I was wondering if I have a database called rfp, if this would be the correct connection string: $dbh=DBI->connect(dbi:Pg:dbname=rfp) || die "$!\n";?

Replies are listed 'Best First'.
Re: Re: PGSQL / DBI
by sutch (Curate) on Mar 19, 2001 at 08:25 UTC
    Try getting rid of the trailing semicolon. psql doesn't like it.

    I create DBI database handles like so:

    my $data_source = "dbi:Pg:dbname=links"; my $dbh = DBI->connect( $data_source, $username, $password );

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://65356]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (3)
As of 2021-04-11 10:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?