From: | David W Noon <dwnoon(at)ntlworld(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Order of execution in shell echo to psql |
Date: | 2010-05-02 13:12:06 |
Message-ID: | 20100502141206.6b66c2a7@memphis.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)ntlworld(dot)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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-05-02 14:20:53 | Re: int2vector |
Previous Message | John Gage | 2010-05-02 12:13:52 | Order of execution in shell echo to psql |