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

Hello

2012/12/7 Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)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(at)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general