PostgreSQL is an actively used query language created in 1986. PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. As a database server, its primary functions are to store data securely and return that data in response to requests from other software applications. It can handle workloads ranging from small single-machine applications to large Internet-facing applications (or for data warehousing) with many concurrent users; on macOS Server, PostgreSQL is the default database; and it is also available for Microsoft Windows and Linux (supplied in most distributions). Read more on Wikipedia...
- PostgreSQL ranks in the top 10% of languages
- the PostgreSQL website
- the PostgreSQL wikipedia page
- PostgreSQL on github
- PostgreSQL first appeared in 1986
- the PostgreSQL team is on twitter
- Have a question about PostgreSQL not answered here? Email me and let me know how I can help.
Example code from the Hello World Collection:
-- Hello World in PL/pgSQL (PostgreSQL Procedural Language) -- In old versions replace '$$' by double qoutes CREATE FUNCTION hello_world() RETURNS text AS $$ BEGIN RETURN 'Hello World'; END $$ LANGUAGE plpgsql; SELECT hello_world();
Last updated June 22nd, 2020