Postgres Pro
Downloads
Home   >   mailing lists

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

From Rosser Schwarz
Subject Re: proposal: multiple psql option -c
Date
Msg-id CAFnxYwgZHajiMMXmVX=ypxXtrZ1swxqawRQ6ud47pCrUT1E0YA@mail.gmail.com
Whole thread Raw
In response to Re: proposal: multiple psql option -c  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: proposal: multiple psql option -c
List pgsql-hackers
Tree view
On Thu, Jul 16, 2015 at 1:44 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
2015-07-16 22:07 GMT+02:00 Fabrízio de Royes Mello <fabriziomello@gmail.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'

--
:wq

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: proposal: multiple psql option -c
Next
From: Pavel Stehule
Date:
Subject: Re: proposal: multiple psql option -c