Additional Features in This Version

As well as the major features named above, there are numerious other new features and improvements which will be of great interest to existing PostgreSQL users.

Functions:  PostgreSQL functions now support emacs-style $dollar$ quoting allowing users to avoid messy nested quotes.  Further, as an benefit of the new Savepoints, PL/pgSQL functions now have limited exception-handling ability using the EXCEPTION clause.

Database Design:  Database administrators can now change columns in-place to other compatible data types using ALTER TABLE.  Declaration of columns with composite data types is now supported per the ANSI SQL99 specification.

Data Import/Export:  The COPY command now supports the very common CSV file format, making imports and exports to other software easier.

Optimizer Improvements:  The query planner and executor will now make use of indexes for compatible data types, greatly reducing the necessity to CAST constant values. This version also brings including improved index usage, better optimization of OR clauses, improved sampling for ANALYZE, faster TRUNCATE, and better planning of prepared query plans, as well as many minor improvements too numerous to count.

Logging:  Administrators may now set up automated rotation of the PostgreSQL log through the postgresql.conf file.  PostgreSQL logging is also much more configurable than before, including administrator-formatted line prefixes, logging specific types of SQL statements, and logging disconnections.

Of course, there are many other changes and improvements.  See the <a href="">Release Notes</a> for the complete list.

Where to Download 8.0:
	Bittorrent
	List of FTP Mirrors
	Windows Installer (also available via Bittorrent)

Links To Other PostgreSQL Resources:

Documentation:
	Official Docs
	TechDocs
	General Bits

Drivers:
	JDBC
	ODBC
	.Net

Graphical User Interfaces:
	pgAdminIII
	phpPGAdmin
	pgAccess
	List of other GUIs

Replication:
	Slony-I
	pgReplicator
	eRServer
	dbMirror