dustbuster has asked for the wisdom of the Perl Monks concerning the following question:

Well, I finally got Postgres and Perl to do their thing.
Turns out all I had to do was crash Red Hat and reinstall!

Anyway I now have more questions:
1)How do I add a user to pg_shadow?

2)A sample script has use Pg; instead of use DBI.
Can anyone direct me to some tutorials so I can learn
about Pg and its methods. I would like somewhere I
can look at sample scripts that have explinations?

3)Do the man file have anything usefull?

As always any help would be greatly appreciated.
D.

Replies are listed 'Best First'.
Re: Perl, Pg, and Postgres
by Arguile (Hermit) on Nov 06, 2001 at 07:28 UTC
    1. 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.
    2. 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.
    3. See above.
[reply]
      I'll look into those links.
      Do you know a site where there are tutorials or
      code that I can compare too?
      D.
[reply]

Back to Seekers of Perl Wisdom