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

From Pavel Stehule
Subject Re: proposal: multiple psql option -c
Date
Msg-id CAFj8pRDLPqkmV0pWL0cfSw4P8Dr8XTdf14hc48C80APLBacY9Q@mail.gmail.com
Whole thread Raw
In response to Re: proposal: multiple psql option -c  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: proposal: multiple psql option -c  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers


2015-07-27 20:32 GMT+02:00 Robert Haas <robertmhaas@gmail.com>:
On Sat, Jul 25, 2015 at 5:27 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> It will be nice side effect, but my primary problem was a impossibility to
> combine VACUUM and any other statement to one simple psql call.

Seems like you can do that easily enough:

[rhaas pgsql]$ (echo 'SELECT 1;'; echo 'VACUUM;'; echo 'SELECT 2;') | psql
 ?column?
----------
        1
(1 row)

VACUUM
 ?column?
----------
        2
(1 row)


how I can do it with xargs?

Regards

Pavel
 
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: RFC: replace pg_stat_activity.waiting with something more descriptive
Next
From: Alvaro Herrera
Date:
Subject: Re: RFC: replace pg_stat_activity.waiting with something more descriptive