Postresql: need a way to initiate a database with a test user

[Tom Browder <tom.browder@gmail.com>]

I get the following error when trying to create a table with psql:

  psql:  FATAL:   Peer authentication failed for user "sql92"

  The spawned command 'psql -f ./t/t.sql -U sql92' exited unsuccessfully (exit code: 2)

The sql file has two create table commands.

I had already created the user 'sql92' with password = '' and createdb privileges.

Is there any way to create a user that can be used outside an open database connection in a script?

Thanks.

Best regards,

-Tom