Re: 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";?

Comment on Re: PGSQL / DBI Select or Download Code

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 );` [download]	[reply] [d/l]