Re: How to mix psql commands and SQL commands on the shell command line?

Hello

2012/12/7 Aleksey Tsalolikhin <atsaloli.tech@gmail.com>:
> How can I mix psql commands and SQL commands on the shell command line, please?
>
> $ psql
> psql (9.2.1)
> Type "help" for help.
>
> ddcKeyGen=> \timing \\ select count(*) from auth_users;
> Timing is on.
>  count
> -------
>    276
> (1 row)
>
> Time: 1.730 ms
>
> $ psql -c "\timing \\ select count(*) from auth_users;"
> Timing is on.
> $
>

you can try pipe

pavel@nemesis ~ $ echo $'\\timing\nselect 10;' | psql postgres
Timing is on.
 ?column?
──────────
       10
(1 row)

Time: 0.478 ms

Regards

Pavel Stehule

> It seems like psql discards everything after the first psql
> argument...  Is there another way to mix psql and SQL commands on the
> shell command line?
>
> Best,
> Aleksey
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general