You don't, or shouldn't directly. Check out Bruce's book on Creating Users. Or you can also view the CREATE USER syntax in the PostgreSQL Refference Manual.
You should check CPAN for Pg and DBD::Pg. Personally I'd stick with DBI (DBD::Pg is a PostgreSQL driver for DBI) as it's a consistant API across many different databases.