Re: Order of execution in shell echo to psql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Order of execution in shell echo to psql
Date: 2010-05-02 14:25:54
Message-ID: 10622.1272810354@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David W Noon <dwnoon(at)ntlworld(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-05-02 14:48:32 Re: postgres crashes - could not reattach to shared memory
Previous Message Tom Lane 2010-05-02 14:20:53 Re: int2vector