Redirecting the output of a query

Hello Everyone,

I am new to postgresql and trying to find a way to redirect the output of a
query to a file. I tried spool but it didn't work, am I missing some thing.
Could any one help. Thanks for your time.

Syed