-----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] ====================================================================== dwn...@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----- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
