PostgreSQL

PostgreSQL is an actively used query language created in 1996. 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...

24Years Old

322,846Users

3,138Jobs

• PostgreSQL ranks in the top 10% of languages
• the PostgreSQL website
• the PostgreSQL wikipedia page
• PostgreSQL on github
• PostgreSQL first appeared in 1996
• the PostgreSQL team is on twitter
• See also: c, linux, sql, gist, xml, xpath, json, julia, go, r, d, erlang, plpgsql, pl-sql, sql-psm, perl, python, tcl, java, javascript, ruby, regex, tls, freebsd, solaris, x86-isa, powerpc, systemz, sparc, arm, mips, visual-basic, mysql, aws
• 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 January 28th, 2020

Edit PostgreSQL on GitHub