simple questions.

I sent this in about 3 days ago but i never saw it come back and i
didn't get a bounce either if i used the wrong address. If this is a
double post sorry.
Scott

or at least i hope they are.

1 how do i put the output of the query into a file from psql.(in oracle
it uses spool filename and then spool off)

2 how do i specify that i want a value greater then 20 but less then
30. seperatly they are easy
select ? where xyz >19
select ? where xyz <31
but if i want only answers 20-30???

i read through a good portion of the docs that i could find and didn't
see either of the answers...

Thanks,
Scott