On Sun, Nov 25, 2012 at 12:35 AM, CS DBA <cs_...@consistentstate.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/