Re: Doing a \set through perl DBI ?

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wednesday, June 6, 2018, David Gauthier <davegauthierpg@xxxxxxxxx> 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.