PostgreSQL
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...
34Years 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 1986
- 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 August 9th, 2020