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

From David W Noon
Subject Re: Order of execution in shell echo to psql
Date
Msg-id 20100502141206.6b66c2a7@memphis.local
Whole thread Raw
In response to Order of execution in shell echo to psql  (John Gage <jsmgage@numericable.fr>)
Responses Re: Order of execution in shell echo to psql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sun, 2 May 2010 14:13:52 +0200, John Gage wrote abour [GENERAL]
Order of execution in shell echo to psql:

>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 try using
proper copy-and-paste when writing your messages.]
- -- 
Regards,

Dave  [RLU #314465]
======================================================================
dwnoon@ntlworld.com (David W Noon)
======================================================================
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.14 (GNU/Linux)

iEYEARECAAYFAkvdeiwACgkQRQ2Fs59Psv/1FQCgw+m+tBm+5VtnMPFrMn+q6xnV
gwMAoNIHaCb3vVSyu35w8aJ9IZfmKV6g
=vnpA
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: John Gage
Date:
Subject: Order of execution in shell echo to psql
Next
From: Tom Lane
Date:
Subject: Re: int2vector