Hi David, Thank you for the swift response.
However, could you please confirm if the below scenario is expected. - included the alias in the file. - And passed the file with psql and it worked. *-bash-4.2$ cat test * *:testing* *-bash-4.2$ /opt/PostgreSQL/9.6/bin/psql -f test * * id * *----* * 1* On Wed, Aug 29, 2018 at 8:44 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wednesday, August 29, 2018, saurabh shelar <saurabhshel...@gmail.com> > wrote: >> >> As per the document from PG-9.6 it is possible. >> > > You cannot use psql variables with -c > > “ command must be either a command string that is completely parsable by > the server (i.e., it contains no psql-specific features), or a single > backslash command.” > > https://www.postgresql.org/docs/10/static/app-psql.html > > David J. > >
