Re: BUG #9198: psql -c 'SET; ...' not working

On Wed, Feb 12, 2014 at 1:40 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> christoph(dot)berg(at)credativ(dot)de writes:
> > This seems to be a bug:
>
> > time psql -c "SET statement_timeout = '3s'; SELECT pg_sleep(2)"
> > ERROR: canceling statement due to statement timeout
> > real 0m1.065s
>
>
> Many people have complained that it's unintuitive that -c works this way
> rather than breaking up the string into multiple submissions the same way
> psql would do with normal input. We're afraid to change it for fear of
> breaking applications, though. If you want behavior more like psql's
> normal operation, consider
>
> echo "SET statement_timeout = '3s'; SELECT pg_sleep(2)" | psql
>
>
How if psql could handle multiple "-c" commands, something like this:

psql -c "SET statement_timetout = '3s'" -c "SELECT pg_sleep(2)"

It wouldn't break existent applications and would make simpler to work on
scripts.

Best regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres