PostgreSQL is a robust, next-generation, Object-Relational DBMS
(ORDBMS), derived from the Berkeley Postgres database management
system. While PostgreSQL retains the powerful object-relational data model,
rich data types and easy extensibility of Postgres, it replaces the PostQuel
query language with an extended subset of SQL.
PostgreSQL is a derivation of postgres V4.2. PostgreSQL retains essentially all the salient features of
postgres. Thus, PostgreSQL is
- Relational. One of original research goals of the postgres project was to show that an essentially
relational DBMS can be extended to handle complex objects, rules, and be highly extensible.
PostgreSQL includes features found in most full fledged relational DBMS's such as declarative
queries in SQL, query optimization, concurrency control, transactions, and multi-user support.
- Highly Extensible. PostgreSQL allows user-defined operators, types, functions, and access
- Object-relational. Some have used the term "object-relational" to describe PostgreSQL because
it supports some object-oriented features such as inheritance.
Current Version: 7.0beta
License Type: BSD Type & Commercial
http://www.illustra.com (PostgreSQL is commercialised & sold by Illustra Inc.)
Source Code Availability: Yes
Available Binary Packages:
- Debian Package: Yes, (in stable (libc5) is Postgres95 1.09, and in the unstable (hamm) is PostgreSQL 6.2.1 with latest patches)
- RedHat RPM Package: Yes, ftp://ftp.redhat.com/pub/contrib/ (postgresql-*)
- Other Packages: ??
FreeBSD, NetBSD, Linux (Intel/Alpha/Sparc), SGI, Solaris (Sparc/x86), SunOS,
HP/UX, BSDI, GD-UX, AIX, Nextstep, Ultrix, OSF/1, System V R4.2.
ftp://ftp.postgresql.org/pub (Primary FTP)
http://metalab.unc.edu/LDP/HOWTO/PostgreSQL-HOWTO.html (PostgreSQL Database-HOWTO)
Mailing Lists/USENET News Groups:
See A Screen Shot? (Not Yet)