How do I pipe output from query to a file in PostgreSQL?

["Penrod, John" <John.Penrod@xxxxxxxxxx>]

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

262 Danny Thomas Place, MS 0574

Memphis, TN  38105

Phone: (901) 595-4941

FAX: (901) 595-2963

john.penrod@xxxxxxxxxx

 

 

  ________________________________  

Email Disclaimer: www.stjude.org/emaildisclaimer