Re: Issue with psqlrc with command line.

[saurabh shelar <saurabhshelar5@xxxxxxxxx>]

Hi David,

Thank you for the help.

I was just got confused with the below line mentioned in the document. However, it seems it is still the same behaviour (i.e --no-psqlrc).

"Before PostgreSQL 9.6, the -c option implied -X (--no-psqlrc); this is no longer the case."

On Wed, Aug 29, 2018 at 8:54 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Wednesday, August 29, 2018, saurabh shelar <saurabhshelar5@xxxxxxxxx> wrote:

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

 Yes.  It’s only -c that is constrained. (There may be some interplay with whether psqlrc is consulted in various situations as well...)

David J.