Re: Help with exporting data

>>>>> On Fri, 28 Feb 2003 15:39:30 +1300, Brent Wood
>>>>> <b(dot)wood(at)niwa(dot)co(dot)nz> said:

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

There are psql options to turn off the headers and footers and to
select your own field seperator. You probably want some
combination of

\pset format unaligned
\pset tuples_only
\pset fieldsep 'field_seperator_character'

--
Jason Larke- jlarke(at)uu(dot)net- http://www.nnaf.net/~jlarke Send mail for PGP key
I don't speak for UUNET or Worldcom. I speak for Odin. And he's *pissed*.
Any sufficiently advanced weapon is indistinguishable from a practical joke.
"People change, and smile: but the agony abides."-T.S. Eliot, The Dry Salvages