MIME-Version: 1.0
References: 
 <CAJSrDUqgMx2+bhX0f9MWDT9LyC4E44wFbTiqC+wboHc__QyV_g@mail.gmail.com>
In-Reply-To: 
 <CAJSrDUqgMx2+bhX0f9MWDT9LyC4E44wFbTiqC+wboHc__QyV_g@mail.gmail.com>
From: Feike Steenbergen <feikesteenbergen@gmail.com>
Date: Fri, 3 May 2024 18:43:42 +0200
Message-ID: 
 <CAK_s-G0DXgxRJHbhcaUFyBi5+CW-C9J2u-m8RXWsw9CB=q6YvA@mail.gmail.com>
Subject: Re: How to pass arguments in postgres to sql scripts.
To: kunwar singh <krishsingh.111@gmail.com>
Cc: pgsql-sql@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CAK_s-G0DXgxRJHbhcaUFyBi5%2BCW-C9J2u-m8RXWsw9CB%3Dq6YvA%40mail.gmail.com>
Precedence: bulk

On Sat, 27 Apr 2024 at 15:03, kunwar singh <krishsingh.111@gmail.com> wrote=
:
>
> Hi friends,  Question: How to pass arguments in postgres to sql scripts. =
Context. When I am monitoring my production Oracle databases I have a lot o=
f simple sql scripts (which require one or more arguments)  which make my m=
onitoring/troubleshooting life simpler. How can I achieve the same in postg=
res? We are migrating our Oracle databases to Postgres  and I am modifying =
my scripts to do the same in Postgres.

One way to do it is with --set

$ psql --set var1=3Dpostgres -AtXq
postgres=3D# select pid from pg_stat_activity where usename=3D:'var1';
185
1939

Kind regards,

Feike Steenbergen