simple questions. - Mailing list pgsql-general

From oxygen
Subject simple questions.
Date
Msg-id 199808180213.TAA04593@dudley.dnc.net
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: Anthony Symons
Date:
Subject: Postgres support for grg
Next
From: "G.Elangovan "
Date:
Subject: Re: [GENERAL] Database Connect Permission