Re: proposal: multiple psql option -c - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: proposal: multiple psql option -c
Date
Msg-id 55B69F67.1040907@BlueTreble.com
Whole thread Raw
In response to Re: proposal: multiple psql option -c  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On 7/27/15 2:57 PM, Andrew Dunstan wrote:
>>
>> psql -At -c "select datname from pg_database" postgres | xargs -n 1 -P
>> 3 psql -c "select current_database()"
>>
>>
>
>
> I don't think it's going to be a hugely important feature, but I don't
> see a problem with creating a new option (-C seems fine) which would
> have the same effect as if the arguments were contatenated into a file
> which is then used with -f. IIRC -c has some special characteristics
> which means it's probably best not to try to extend it for this feature.

+1. I've occasionally wanted this as well.

I'd also vote for -C returning every state string as well.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Data in Trouble? Get it in Treble! http://BlueTreble.com



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: RFC: replace pg_stat_activity.waiting with something more descriptive
Next
From: Andres Freund
Date:
Subject: WIP: Make timestamptz_out less slow.