Postgres Pro
Downloads
Home   >   mailing lists

Doing a \set through perl DBI ? - Mailing list pgsql-general

From David Gauthier
Subject Doing a \set through perl DBI ?
Date
Msg-id CAMBRECBL6N6Mrt12R1sJfLbG=B4igQ+Pv7KdLwRbNL5Omx9ejg@mail.gmail.com
Whole thread Raw
Responses Re: Doing a \set through perl DBI ?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Doing a \set through perl DBI ?  (Francisco Olarte <folarte@peoplecall.com>)
List pgsql-general
Tree view
Hi:

Is there a way to do the equivalent of a "\set foo 1" through perl dbi ?
I tried... 
    $dbh->do("\\set foo 1");
and got a syntax error

Of course, I'd also have to be able to access the value of foo once its set.   I'm guessing the usual way ??? (select :foo)


Thanks for any help !

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Code of Conduct plan
Next
From: "David G. Johnston"
Date:
Subject: Re: Doing a \set through perl DBI ?