Postgres Pro
Downloads
Home   >   mailing lists

How do I pipe output from query to a file in PostgreSQL? - Mailing list pgsql-general

From Penrod, John
Subject How do I pipe output from query to a file in PostgreSQL?
Date
Msg-id 8172D639BA76A14AA5C9DE7E13E0CEBE02F442BC0D@SJMEMXMBS10.stjude.sjcrh.local
Whole thread Raw
Responses Re: How do I pipe output from query to a file in PostgreSQL?
Re: How do I pipe output from query to a file in PostgreSQL?
List pgsql-general
Tree view
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
 
 

  ________________________________  

pgsql-general by date:

Previous
From: David Kerr
Date:
Subject: Re: Postmaster taking 100% of the CPU
Next
From: Kevin Kempter
Date:
Subject: Re: How do I pipe output from query to a file in PostgreSQL?