Thread: BUG #7536: run arbitrary -c setup command before interaction [wishlist]

BUG #7536: run arbitrary -c setup command before interaction [wishlist]

From
bugs@bereft.net
Date:
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