System / Global psqlrc file location

[CS DBA]

Hi all;

where does the system psqlrc file live?

Thanks in advance

[Raghavendra]

Post by CS DBA
Hi all;
where does the system psqlrc file live?
Thanks in advance
Default is ~/.psqlrc. (postgres user)

You can check the sample file
under /opt/PostgreSQL/9.2/share/postgresql/psqlrc.sample.

If you want to read from any different location then set environment
variable PSQLRC.
http://www.postgresql.org/docs/9.2/static/app-psql.html

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/