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: 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) > ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
