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

From Pavel Stehule
Subject Re: proposal: multiple psql option -c
Date
Msg-id CAFj8pRCE8N3bLvRfAk5i8gNDmP0=bQCHHtD_Ru8uVLLKHvnjfw@mail.gmail.com
Whole thread Raw
In response to Re: proposal: multiple psql option -c  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: proposal: multiple psql option -c  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers


2015-07-27 21:57 GMT+02:00 Andrew Dunstan <andrew@dunslane.net>:

On 07/27/2015 02:53 PM, Pavel Stehule wrote:




I am trying to run parallel execution

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.

ok, I'll try to write patch.

Pavel
 

cheers

andrew

pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: MultiXact member wraparound protections are now enabled
Next
From: Joe Conway
Date:
Subject: Re: more RLS oversights