On Monday 26 October 2009 12:03:13 Penrod, John wrote: > In oracle: > > SPOOL filename.txt > Select * from customer; > SPOOL OFF > > Results are piped to filename.txt > > > How do I do this from the psql command line? > > > John J. Penrod, OCP > Oracle/EnterpriseDB Database Administrator > St. Jude Children's Research > Hospital<http://www.stjude.org/stjude/v/index.jsp?vgnextoid=f2bfab46cb1180 > 10VgnVCM1000000e2015acRCRD&plt=STJGENSEGOOGL0000009&gclid=CM6Imp6I0Z0CFSMND > QodNXLerQ> 262 Danny Thomas Place, MS 0574 > Memphis, TN 38105 > Phone: (901) 595-4941 > FAX: (901) 595-2963 > john.pen...@stjude.org > > > > > ________________________________ > Email Disclaimer: www.stjude.org/emaildisclaimer >
psql postgres=# \o file.out postgres=# select * from customer; -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
