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.
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.
PostGIS adds support for geographic objects to the PostgreSQL object-relational
database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing
it to be used as a backend spatial database for geographic information systems
(GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS follows the
OpenGIS "Simple Features Specification for SQL" and has been certified as
compliant with the "Types and Functions" profile.
PostGIS development was started by Refractions Research as a project in open
source spatial database technology. PostGIS is released under the GNU General
Public License. PostGIS continues to be developed by a group of contributors led
by a Project Steering Committee and new features continue to be added.
PostGIS adds support for geographic objects to the PostgreSQL object-relational
database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing
it to be used as a backend spatial database for geographic information systems
(GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS follows the
OpenGIS "Simple Features Specification for SQL" and has been certified as
compliant with the "Types and Functions" profile.
PostGIS development was started by Refractions Research as a project in open
source spatial database technology. PostGIS is released under the GNU General
Public License. PostGIS continues to be developed by a group of contributors led
by a Project Steering Committee and new features continue to be added.
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.
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.
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.
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.