What is PostgreSQL
It is an object-relational database management system based on Postgres Version 4.2 developed by University of California at Barkeley Computer Science Department.
It support large part of the SQL standard and offers many modern features and It is an open source.
- Complex Queries
- Foreign Keys
- Triggers
- Updatable Views
- Transaction integrity
- Multiversion Concurrency Control
PostgreSQL can be extended by the user in many way:
- Data types
- Functions
- Operators
- Aggregate Functions
- Index Methods
- Procedural Languges
PostgreSQL can be used modified and distributed by anyone free of charge for any purpose, be it private commercial and academic.
Brief History of PostgreSQL
PostgreSQL previously called The object-relational database management system derived from Postgres package written in University of California at Berkeley. Now PostgreSQL is now the most advanced open-sources database available anywhere.
Postgres95
In 1994, Andrew Yu and Jolly Chen added an SQL Language interpreter to Postgres. Under a New name Postgres95 and subsequently released to the web to find its own way in the world as an open-source descendant of the original Postgres Berkley code.
PostgreSQL
In 1996 name was changed from Postgres95 to PostgreSQL to reflect the relationship between the original Postgres and the more recent versions with SQL capabilities.
Convention
The following conventions are used in the synopsis of a command.
- Brackets "[ and ]" which Indicates optional parts.
- Braces "{ and }" and vertical lines "|" indicate that you must choose one alternative.
- Dots "..." indicated that the preceding element can be repeated. And all other symbols including parentheses should be taken literally.
SQL commands are preceded by the prompt =>, and shell commands are preceded by the prompt $. Normally, prompts are not shown through.
Bug Reporting Guidlines
Big report plays an important role in making PostgreSQL more reliable because even the utmost care cannot guarantee that every part of PostgreSQL will work on every platform under every circumstances.
Identifying Bugs
- A program terminates with a fatal signal or an operating system error message that would point to a problem in the program.
- A program produces the wrong output for any given input
- A program refuses to accept the valid input.
- A program accepts invalid input without a notice or error message
- PostgreSQL fails to compile build or install according to the instructions on supported platforms
Top comments (0)