Re: Multiple psql -c / -f options

On 10/18/2013 02:19 AM, Fabien COELHO wrote:
>
>> IMHO the current behavior is broken:
>>
>> decibel@decina:[17:46]~/pgsql/HEAD/i$bin/psql -c 'select 1' -c 
>> 'select 2'
>> ?column?
>> ----------
>>        2
>> (1 row)
>
> Another try with one -c but with similar results:
>
>   sh> psql -c "SELECT 1; SELECT 'hello';"
>     ?column?
>     ----------
>     hello
>     (1 row)
>
>   sh> psql -V
>     psql (PostgreSQL) 9.3.1
>


It's not broken. All this behaviour is documented fairly explicitly. See 
<http://www.postgresql.org/docs/current/static/app-psql.html> For 
example, regarding Fabio's example, which is actually very different 
from Jim's, the docs say: "only the result of the last SQL command is 
returned."

If you want to argue that it should be enhanced, then do. But it's 
acting as designed and as documented.

I suspect changing this might actually have more wrinkles that you 
imagine, but I could be wrong.

Incidentally, both of you could probably achieve what you apparently 
want with:
   echo 'some sql here' | psql


cheers

andrew