BUG #7536: run arbitrary -c setup command before interaction [wishlist] - Mailing list pgsql-bugs

From bugs@bereft.net
Subject BUG #7536: run arbitrary -c setup command before interaction [wishlist]
Date
Msg-id E1TC357-00022O-3q@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Fujii Masao
Date:
Subject: Re: BUG #7533: Client is not able to connect cascade standby incase basebackup is taken from hot standby
Next
From: Fujii Masao
Date:
Subject: Re: BUG #7534: walreceiver takes long time to detect n/w breakdown