Thread: How do I pipe output from query to a file in PostgreSQL?
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
262 Danny Thomas Place, MS 0574
Memphis, TN 38105
Phone: (901) 595-4941
FAX: (901) 595-2963
john.penrod@stjude.org
________________________________
Email Disclaimer: www.stjude.org/emaildisclaimer
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.penrod@stjude.org > > > > > ________________________________ > Email Disclaimer: www.stjude.org/emaildisclaimer > psql postgres=# \o file.out postgres=# select * from customer;
On 26/10/2009 18:03, 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? \g <filename> will execute the query and send the result to <filename>. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie