PostgreSQL is a sophisticated Object-Relational DBMS, supporting
almost all SQL constructs, including subselects, transactions, and
user-defined types and functions. It is the most advanced open-source
database available anywhere. Commercial Support is also available.
The original Postgres code was the effort of many graduate students,
undergraduate students, and staff programmers working under the direction of
Professor Michael Stonebraker at the University of California, Berkeley. In
1995, Andrew Yu and Jolly Chen took on the task of converting the DBMS query
language to SQL and created a new database system which came to known as
Postgres95. Many others contributed to the porting, testing, debugging and
enhancement of the Postgres95 code. As the code improved, and 1995 faded into
memory, PostgreSQL was born.
PostgreSQL development is presently being performed by a team of Internet
developers who are now responsible for all current and future development. The
development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG).
Support is available from the PostgreSQL developer/user community through the
support mailing list (questions@PostgreSQL.ORG).
PostgreSQL is free and the complete source is available.
This is the port for all stuff that comes in the contrib subtree of
the postgresql distribution. This subtree contains porting tools,
analysis utilities, and plug-in features that are not part of the core
PostgreSQL system, mainly because they address a limited audience or
are too experimental to be part of the main source tree. This does
not preclude their usefulness.
Each subdirectory contains a README file with information about the
module. Some directories supply new user-defined functions, operators,
or types. After you have installed the files you need to register the
new entities in the database system by running the commands in the
supplied .sql file. For example,
$ psql -d dbname -f module.sql
The .sql files are installed into /usr/local/share/postgresql/contrib
For more information, please see
/usr/local/share/doc/postgresql/contrib/README*
This software is part of the standard PostgreSQL distribution.
MySQL is a very fast, multi-threaded, multi-user and robust SQL
(Structured Query Language) database server.
Pgeasy is a PostgreSQL API that is a cleaner interface to the libpq
library, more like an SQL 4GL interface.
There are examples in share/examples/postgresql/libpqeasy
and docs in share/doc/postgresql/libpqeasy