Re: Order of execution in shell echo to psql - Mailing list pgsql-general

David W Noon <dwnoon@ntlworld.com> writes:
> On Sun, 2 May 2010 14:13:52 +0200, John Gage wrote abour [GENERAL]
>> I issue the following command to the shell:
>>
>> echo '\o file.txt \\ select * from table_name limit 10  \o ' | psql --
>> host 'localhost' --port 5432 --username 'johngage' 'database_name'

> Try putting a semi-colon at the end of your SQL query.

Or put a \g there.  As it stands, execution of the SQL query is
triggered by the EOF at the end of the string.  So the fact that the
second \o got executed before that is unsurprising.

            regards, tom lane