Re: [GENERAL] Perl DBD?

There seems to be some confusion here.

The Pg module and the DBI modules are NOT the same thing. The first is a
postgreSQL specific perl module. The second is an API; it has a standard
set of commands and these are applied to the database of your choice using
the appropriate driver (in this case DBD::Pg).

The fact that you mention use pg; (which by the way should be use Pg;)
implies you're trying to use the former. But if you've already installed
DBI/DBD::Pg, why not use these instead of the Pg module?

Try

perldoc DBI
perldoc DBD::Pg

for more info on these.

If you want to use Pg get and install the Pg module from CPAN and try

perldoc Pg

or recompile postgreSQL with the --with-perl switch.

oh, and to view the tables in a database

psql <database>
\dt

HTH,

S.

>I would like to use a perl-script together with postgresql. Therefore I have
>to use the following line:
>
>use pg;
>
>I know I have to install a DBD herefore, but where can I get it? I have
>installed DBD-pg-0.92, DBI-1.06 and postgresql-6.4.2.
>A second (short) question:
>How can I view the tables in a DB?
>Thanks in advance,
>
> Jeroen Hermans
> Webmaster HaFaBra.nl
> info(at)hafabra(dot)nl
>
>____________________________________________
>
>De ideale LINK tussen muziek en internet:
>
>De Nationale HaFaBra-pagina, http://www.hafabra.nl
>
>Een must voor iedere muziekliefhebber!
>____________________________________________

+--------------------------+--------------------------------------+
| Stuart C. G. Rison | Ludwig Institute for Cancer Research |
+--------------------------+ 91 Riding House Street |
| N.B. new phone code!! | London, W1P 8BT |
| Tel. +44 (0)207 878 4041 | UNITED KINGDOM |
| Fax. +44 (0)207 878 4040 | stuart(at)ludwig(dot)ucl(dot)ac(dot)uk |
+--------------------------+--------------------------------------+