[GENERAL] 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 St. Jude Children's Research Hospital

[GENERAL] Has anyone seen this while running pg_dumpall?

We are running version: edb=# select version(); version - EnterpriseDB 8.3.0.106 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.1.0 (1 row) Has anyone seen this w

Re: [GENERAL] Has anyone seen this while running pg_dumpall?

rrera [mailto:alvhe...@commandprompt.com] Sent: Wednesday, October 28, 2009 12:55 PM To: Penrod, John Cc: 'pgsql-general@postgresql.org'; 'pgsql-ad...@postgresql.org' Subject: Re: [GENERAL] Has anyone seen this while running pg_dumpall? Penrod, John wrote: > We are running versi