Skip site navigation (1) Skip section navigation (2)

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

From: bugs(at)bereft(dot)net
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7536: run arbitrary -c setup command before interaction[wishlist]
Date: 2012-09-13 06:39:21
Message-ID: E1TC357-00022O-3q@wrigleys.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7536
Logged by:          Brad Bowman
Email address:      bugs(at)bereft(dot)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

Next:From: Amit KapilaDate: 2012-09-13 06:51:22
Subject: Re: BUG #7533: Client is not able to connect cascade standby incase basebackup is taken from hot standby
Previous:From: Amit KapilaDate: 2012-09-13 04:22:08
Subject: Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group