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

From David Gauthier
Subject Re: Doing a \set through perl DBI ?
Date
Msg-id CAMBRECA_KefdGs8_dCgxY06o=-Jv=XxkmWoP1VBWXr=eUECLyQ@mail.gmail.com
Whole thread Raw
In response to Re: Doing a \set through perl DBI ?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
I think I found my own answer.  I wanted to use the current linux user's uid as part of a query (again, this is a perl/DBI script).  I was thinking I might be able to set a variable into the DB session somehow using \set through DBI to accomplish this.  The solution that finally occurred to me was to create a temporary table and have the perl script shove the uid into a column in that table, then query against that.  Sort of like using a temp table to store variables set from outside. 

On Wed, Jun 6, 2018 at 11:46 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wednesday, June 6, 2018, David Gauthier <davegauthierpg@gmail.com> wrote:
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)


No.  Meta commands are psql client program only.  You'd need to explain why you want this to get reasonable server-side suggestions.

David J.
 

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Which backend using which pg_temp_N schema?
Next
From: Jerry Sievers
Date:
Subject: Re: Which backend using which pg_temp_N schema?