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 "...."|psqlThought it was strange. > CC: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Change to 'timing on' globally > From: alvhe...@commandprompt.com > To: b...@hotmail.com > 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@postgresql.org) > 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. http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_1
