Help with exporting data

I have an application which is using Postgres to store/manage it's data.

I'd like to be able to export (to text files) the outputs from queries.

There are two ways I've found I can do this.

I can run a select from a shell & redirect the output to a file, then
reformat the file to plain whitespace delimited values.

I can create a new (possibly temp) table with select into & copy the
resulting table to a file. I can't see any other way in the docs, as copy
won't work with views.


Is there a simpler (& more efficient) way to get the result of a select
into a plain text file, without the Postgres header/trailer lines & the
"|" between attributes?


Thanks,

  Brent Wood