SAL Home DBASE Object-Oriented DBMS


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 methods.
  • 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

Home Site: (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, (postgresql-*)
  • Other Packages:   ??

Targeted Platforms:

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.

Software/Hardware Requirements:


Other Links: (Primary FTP) (PostgreSQL Database-HOWTO)

Mailing Lists/USENET News Groups:


User Comments:

See A Screen Shot? (Not Yet)

  SAL Home   |   Database Systems   |   Object-Oriented DBMS

Comments? SAL@KachinaTech.COM
Copyright © 1995-2001 by Herng-Jeng Jou
Copyright © 1997-2001 by Kachina Technologies, Inc.
All rights reserved.