On Sun, Nov 25, 2012 at 12:35 AM, CS DBA <cs_dba(at)consistentstate(dot)com> wrote:
> 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/