sql-info.de

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | Index

In more recent PostgreSQL versions, the command \copy can be used to generate CSV files.

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.

Posted at 2004-10-26 07:23:00

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.

Posted at 2004-10-23 19:00:00

2004-10-22 14:54:00

PostgreSQL | PostgreSQL 8.0

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.

Posted at 2004-10-22 14:54:00

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | Index