On Thu, Jul 16, 2015 at 4:42 PM, Pavel Stehule <pavel.stehule@gmail.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? >
Why you want it if we already have the -f option that cover this use case?
It doesn't help me - we would to run script or remote script (via ssh) without necessity to create (and later drop) files on production servers.
remote execution of scripts is much more simple if you don't need to create any script files.