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@xxxxxxxxx> wrote:
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 errorOf 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.
