psql is an excellent command line tool, but lacks the advanced report formatting facilities of, for example, Oracle's SQL*Plus. However it can be used to output results in several different formats including CSV.
A potential 'data loss' bug and several minor fixes are covered by the latest PostgreSQL "point" releases: 7.2.6, 7.3.8 and 7.4.6 (announcement). Additionally a minor security risk involving the script
make_oidjoins_check's use of temporary files has been fixed.
Source files are available from FTP mirrors, see http://www.postgresql.org/mirrors-ftp.html.
UPDATE: apparently two further, slightly more serious but non-specified security fixes are included in these releases.
The next release of PostgreSQL will be 8.0, the first major version number change since 2000. Expected before the end of the year, 8.0 is not a radical makeover, but contains a bundle of new features improving accessibility, functionality and performance for developers, administrators and users alike.