![]() PostgreSQL |
||||||||||||||||||||||||||||||||||||
| Tags: Oracle |
||||||||||||||||||||||||||||||||||||
|
Description
PostgreSQL is a fully featured object-relational database management system. It supports a large part of the SQL standard and is designed to be extensible by users in many aspects. Some of the features are: ACID transactions, foreign keys, views, sequences, subqueries, triggers, user-defined types and functions, outer joins, multiversion concurrency control. Graphical user interfaces and bindings for many programming languages are available as well.
This package always depends on the latest available database server for PostgreSQL. |
||||||||||||||||||||||||||||||||||||
|
Home Page: http://www.postgresql.org/
|
||||||||||||||||||||||||||||||||||||
|
Interface: Command Line
|
||||||||||||||||||||||||||||||||||||
|
Available deb Repositories (how-to add a respository)
|
||||||||||||||||||||||||||||||||||||
|
Available rpm Repositories
|
||||||||||||||||||||||||||||||||||||
|
Rating: Excellent (1 vote)
Login or Register to rate PostgreSQL, add a Tag, or designate as an alternative to a Windows app |
|
|
Upload Screenshots
Images must be in GIF, JPG, or PNG formats and can be no larger than 2 MB. Only one file can be uploaded at a time. A description can be included, but it is optional.
|
|
|
Submit Web Links
Submit the title and link (including http://) to an article pertaining to PostgreSQL and it will appear in the Web Links section of the right banner. Contact us here if an entry needs to be removed.
|
|




Good alternative to MS-SQL server or Oracle
Very nice product. It is very standards compliant, it have pluggable languages for stored procedures e.g: perl, tcl, or its own pgplsql).
pgplsql is very similar to to Oracle PL/SQL so if you are familliar with that you will quickly get up to speed as a developer.
It comes as a command line application, but there are several graphical admin frontends available as separate downloads, among them the postgresql specific pgAdmin III. If you decide to use it from the command line the cli client is very functional, with built in help system and autocomplete features.
At the moment it probably have the fastest full text search engine there is all categories (open source or otherwise). The fulltext search also have support for a long list of languages.