[ADMIN] command prompt select statement

[JT Kirkpatrick]

hello oh-more-knowledgable-than-me postgres folks!

i'd like to run a select statement tonight after everyone is gone, and i 
don't feel like coming back in to do it (last person gone at 11pm).  i need 
the output saved to a file, if possible.  how can i do it from the bash 
prompt??  (linux rh 5.2, pg 6.4.2)

jt kirkpatrick / mps

************