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