accessing PG using Perl:DBI

From: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: accessing PG using Perl:DBI
Date: 2007-08-30 08:03:40
Message-ID: 1188461020.18203.64.camel@neuromancer.home.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I'm sure some of you guys do perl-dbi to access perl. need some
pointers. (pg specific I guess)

1. Possible to execute queries to PG using multiple statemments?
eg:
prepare("A")
bind_param($A)
execute()
prepare("BB")
bind_param($B)
execute()
prepare("CC")
bind_param($B)
execute()

right now, I found that this works..

prepare("A;BB;CC")
but not sure how bind_param will work in this context

2. how do I perform a list of SQL using transactions. eg: like above,
but wrap it into a transaction.

Many Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Idan Miller 2007-08-30 08:14:25 PostgreSQL with Kerberos and Active Directory
Previous Message Magnus Hagander 2007-08-30 08:02:40 Re: PostgreSQL.Org (was: PostgreSQL Conference Fall 2007)