also,
$ psql -c "select whatever_you_want from table_name" > outfile
reid
> -----Original Message-----
> From: scott.marlowe [mailto:scott.marlowe@ihs.com]
> Sent: Monday, February 09, 2004 12:17 PM
> To: Russ Schneider
> Cc: pgsql-general
> Subject: Re: [GENERAL] piping output to file
>
>
> On Sun, 8 Feb 2004, Russ Schneider wrote:
>
> > Is there an easy way to pipe a select statement's output to a file?
>
> In psql you can use \o [filename] to direct query output to a file.
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>