dumping query results to a csv - Mailing list pgsql-admin

This is kind of a pg-admin newbie question, so apologies in advance.

Anyway, I'd like to issue a command that dumps the results of a query to
a txt file in comma delimited format.  Does PostgreSQL ship with
something to do this?  I searched the web, but found what appeared to be
non-free solutions.

Thanks,

Dave