The Postgres database that I use does not allow a table named "user". You may want to check if it allows "users" as a table name (or try a different table name).

Did you happen to receive an error message? That would help.

As for the username/password for the database, it is not necessarly the same for the database and your user account. The administrator may have created the same username, but I would be suprised if the passwords were the same.

Postgresql documentation is available at http://www.postgresql.org/users-lounge/docs/7.0/user/.

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

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]

CREATE TABLE users
( uid     INTEGER(4)    PRIMARY KEY,
username  VARCHAR(15)   NOT NULL UNIQUE,
passwd    VARCHAR(10)   NOT NULL,
realname  VARCHAR(50)   ,
email     VARCHAR(50)   NOT NULL UNIQUE,
website   VARCHAR(50)   ,
face      VARCHAR(20)   ,
bio       VARCHAR(75)   );
[download]

Also, it might be worth thinking about dropping the uid column - if both username and email are unique, then you could use either of them as the primary key.

You might well find this book interesting too.

good luck - andy.