The following bug has been logged on the website:
Bug reference: 7536
Logged by: Brad Bowman
Email address: bugs@bereft.net
PostgreSQL version: 9.1.5
Operating system: linux
Description: =
I'd like a -c (or -f) option that doesn't exit immediately. In my case, I'd
like to setup an environment based on dynamic information (search_path,
prompt, temp views, info displayed) and envisage doing it with a -c or
similar. I haven't been able to find other ways to do this.
PGOPTIONS and the new (9.2) PSQLRC would cover some of my needs.
There is a related TODO item ( http://wiki.postgresql.org/wiki/Todo#psql )
Allow processing of multiple -f (file) options
Perhaps allowing multiple -f -c and a fully interactive -f - would do
psql -f setup.sql -c '..info' -f - -c '..summary'
Thanks, hope this isn't just noise,
Brad