Re: Issue with psqlrc with command line.

[saurabh shelar <saurabhshelar5@xxxxxxxxx>]

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

On Wednesday, August 29, 2018, saurabh shelar <saurabhshelar5@xxxxxxxxx> 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.