Re: proposal: multiple psql option -c

2015-07-16 23:10 GMT+02:00 Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com>:

> On Thu, Jul 16, 2015 at 1:44 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> wrote:
>
>> 2015-07-16 22:07 GMT+02:00 Fabrízio de Royes Mello <
>> fabriziomello(at)gmail(dot)com>:
>>
>>> 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.
>>
>
> Does piping a series of commands into psql work in your scenario? You can
> even say things like:
>
> cat $local_file | ssh $production_server 'psql $database'
>

probably not - the first remote command is sudo su - due security reasons

>
> --
> :wq
>