Re: proposal: multiple psql option -c

2015-07-17 0:03 GMT+02:00 dinesh kumar <dineshkumar02(at)gmail(dot)com>:

> On Thu, Jul 16, 2015 at 12:42 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> wrote:
>
>> Hi
>>
>> can we support multiple "-c" option?
>>
>> Why? Because some statements like VACUUM cannot be used together with any
>> other statements with single -c option. The current solution is using echo
>> and pipe op, but it is a complication in some complex scripts - higher
>> complication when you run psql via multiple sudo statement.
>>
>> Example:
>>
>> psql -c "select pg_stat_reset()" -c "vacuum full analyze" dbname
>>
>> or on all db
>>
>> psql -At -c "select datname from pg_databases" postgres | \
>> xargs -n 1 -P 3 psql -c "..." -c "..."
>>
>> Ideas, notes, comments?
>>
>>
> IMO, rather having multiple -c args, it would be good to have another flag
> like "-C" which do accept and execute multiple SQL statements in sequential.
>

it is one possible solution too

multiple -c option has advantage of simple evaluation of backslash
statements .. -c "\l" -c "\dt" - but this advantage is not high important.

Pavel

>
> Best Regards,
> Dinesh
> manojadinesh.blogspot.com
>
>
>> Regards
>>
>> Pavel
>>
>
>