|
Thanks. If I want to do at system-wide level, where do I store the psqlrc file (assuming I want to change the timing behavior system-wide)? (CentOS 5, Postgres 8.4) $ ./pg_config --sysconfdir /opt/PostgreSQL/8.4/etc/postgresql But I don't have /opt/PostgreSQL/8.4/etc/postgresql directory. Just creating the directory and putting a psqlrc file over there does not seem to work. On a side-note, I observered that timing value in ~/.psqlrc was ignored by psql -c "..." command but not by echo "...."|psql Thought it was strange. > CC: pgsql-admin@xxxxxxxxxxxxxx > Subject: Re: Change to 'timing on' globally > From: alvherre@xxxxxxxxxxxxxxxxx > To: b_ki@xxxxxxxxxxx > Date: Mon, 5 Jul 2010 13:10:30 -0400 > > Excerpts from Balkrishna Sharma's message of lun jul 05 13:00:44 -0400 2010: > > > > I know that we can toggle the timing at session level by using \timing in psql. > > Is there a way to set the default to 'timing on' globally across the database or atleast across all psql statements by a specificied user ? > > .psqlrc ? > > -- > Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox. Learn more. |
