PLDB
Languages Features Calendar CSV Lists Blog About Sponsor Add Language
GitHub icon

PostgreSQL

PostgreSQL

PostgreSQL is a query language created in 1986 by Marc G. Fournier.

#25on PLDB 36Years Old 340.8kUsers
40Books 3Papers

Try now: Riju

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...


Example from Riju:
SELECT 'Hello, world!';
Example 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();

Keywords in PostgreSQL

ABORT ABS ABSOLUTE ACCESS ACTION ADA ADD ADMIN AFTER AGGREGATE ALIAS ALL ALLOCATE ALTER ANALYSE ANALYZE AND ANY ARE ARRAY AS ASC ASENSITIVE ASSERTION ASSIGNMENT ASYMMETRIC AT ATOMIC AUTHORIZATION AVG BACKWARD BEFORE BEGIN BETWEEN BIGINT BINARY BIT BITVAR BIT_LENGTH BLOB BOOLEAN BOTH BREADTH BY CACHE CALL CALLED CARDINALITY CASCADE CASCADED CASE CAST CATALOG CATALOG_NAME CHAIN CHAR CHARACTER CHARACTERISTICS CHARACTER_LENGTH CHARACTER_SET_CATALOG CHARACTER_SET_NAME CHARACTER_SET_SCHEMA CHAR_LENGTH CHECK CHECKED CHECKPOINT CLASS CLASS_ORIGIN CLOB CLOSE CLUSTER COALESCE COBOL COLLATE COLLATION COLLATION_CATALOG COLLATION_NAME COLLATION_SCHEMA COLUMN COLUMN_NAME COMMAND_FUNCTION COMMAND_FUNCTION_CODE COMMENT COMMIT COMMITTED COMPLETION CONDITION_NUMBER CONNECT CONNECTION CONNECTION_NAME CONSTRAINT CONSTRAINTS CONSTRAINT_CATALOG CONSTRAINT_NAME CONSTRAINT_SCHEMA CONSTRUCTOR CONTAINS CONTINUE CONVERSION CONVERT COPY CORRESPONDING COUNT CREATE CREATEDB CREATEUSER CROSS CUBE CURRENT CURRENT_DATE CURRENT_PATH CURRENT_ROLE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR CURSOR_NAME CYCLE DATA DATABASE DATE DATETIME_INTERVAL_CODE DATETIME_INTERVAL_PRECISION DAY DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFERRABLE DEFERRED DEFINED DEFINER DELETE DELIMITER DELIMITERS DEPTH DEREF DESC DESCRIBE DESCRIPTOR DESTROY DESTRUCTOR DETERMINISTIC DIAGNOSTICS DICTIONARY DISCONNECT DISPATCH DISTINCT DO DOMAIN DOUBLE DROP DYNAMIC DYNAMIC_FUNCTION DYNAMIC_FUNCTION_CODE EACH ELSE ENCODING ENCRYPTED END END-EXEC EQUALS ESCAPE EVERY EXCEPT EXCEPTION EXCLUSIVE EXEC EXECUTE EXISTING EXISTS EXPLAIN EXTERNAL EXTRACT FALSE FETCH FINAL FIRST FLOAT FOR FORCE FOREIGN FORTRAN FORWARD FOUND FREE FREEZE FROM FULL FUNCTION GENERAL GENERATED GET GLOBAL GO GOTO GRANT GRANTED GROUP GROUPING HANDLER HAVING HIERARCHY HOLD HOST HOUR IDENTITY IGNORE ILIKE IMMEDIATE IMMUTABLE IMPLEMENTATION IMPLICIT IN INCREMENT INDEX INDICATOR INFIX INHERITS INITIALIZE INITIALLY INNER INOUT INPUT INSENSITIVE INSERT INSTANCE INSTANTIABLE INSTEAD INT INTEGER INTERSECT INTERVAL INTO INVOKER IS ISNULL ISOLATION ITERATE JOIN KEY KEY_MEMBER KEY_TYPE LANCOMPILER LANGUAGE LARGE LAST LATERAL LEADING LEFT LENGTH LESS LEVEL LIKE LIMIT LISTEN LOAD LOCAL LOCALTIME LOCALTIMESTAMP LOCATION LOCATOR LOCK LOWER MAP MATCH MAX MAXVALUE MESSAGE_LENGTH MESSAGE_OCTET_LENGTH MESSAGE_TEXT METHOD MIN MINUTE MINVALUE MOD MODE MODIFIES MODIFY MODULE MONTH MORE MOVE MUMPS NAME NAMES NATIONAL NATURAL NCHAR NCLOB NEW NEXT NO NOCREATEDB NOCREATEUSER NONE NOT NOTHING NOTIFY NOTNULL NULL NULLABLE NULLIF NUMBER NUMERIC - 0 OBJECT OCTET_LENGTH OF OFF OFFSET OIDS OLD ON ONLY OPEN OPERATION OPERATOR OPTION OPTIONS OR ORDER ORDINALITY OUT OUTER OUTPUT OVERLAPS OVERLAY OVERRIDING OWNER PAD PARAMETER PARAMETERS PARAMETER_MODE PARAMETER_NAME PARAMETER_ORDINAL_POSITION PARAMETER_SPECIFIC_CATALOG PARAMETER_SPECIFIC_NAME PARAMETER_SPECIFIC_SCHEMA PARTIAL PASCAL PASSWORD PATH PENDANT PLACING PLI POSITION POSTFIX PRECISION PREFIX PREORDER PREPARE PRESERVE PRIMARY PRIOR PRIVILEGES PROCEDURAL PROCEDURE PUBLIC READ READS REAL RECHECK RECURSIVE REF REFERENCES REFERENCING REINDEX RELATIVE RENAME REPEATABLE REPLACE RESET RESTRICT RESULT RETURN RETURNED_LENGTH RETURNED_OCTET_LENGTH RETURNED_SQLSTATE RETURNS REVOKE RIGHT ROLE ROLLBACK ROLLUP ROUTINE ROUTINE_CATALOG ROUTINE_NAME ROUTINE_SCHEMA ROW ROWS ROW_COUNT RULE SAVEPOINT SCALE SCHEMA SCHEMA_NAME SCOPE SCROLL SEARCH SECOND SECTION SECURITY SELECT SELF SENSITIVE SEQUENCE SERIALIZABLE SERVER_NAME SESSION SESSION_USER SET SETOF SETS SHARE SHOW SIMILAR SIMPLE SIZE SMALLINT SOME SOURCE SPACE SPECIFIC SPECIFICTYPE SPECIFIC_NAME SQL SQLCODE SQLERROR SQLEXCEPTION SQLSTATE SQLWARNING STABLE START STATE STATEMENT STATIC STATISTICS STDIN STDOUT STORAGE STRICT STRUCTURE STYLE SUBCLASS_ORIGIN SUBLIST SUBSTRING SUM SYMMETRIC SYSID SYSTEM SYSTEM_USER TABLE TABLE_NAME TEMP TEMPLATE TEMPORARY TERMINATE THAN THEN TIME TIMESTAMP TIMEZONE_HOUR TIMEZONE_MINUTE TO TOAST TRAILING TRANSACTION TRANSACTIONS_COMMITTED TRANSACTIONS_ROLLED_BACK TRANSACTION_ACTIVE TRANSFORM TRANSFORMS TRANSLATE TRANSLATION TREAT TRIGGER TRIGGER_CATALOG TRIGGER_NAME TRIGGER_SCHEMA TRIM TRUE TRUNCATE TRUSTED TYPE UNCOMMITTED UNDER UNENCRYPTED UNION UNIQUE UNKNOWN UNLISTEN UNNAMED UNNEST UNTIL UPDATE UPPER USAGE USER USER_DEFINED_TYPE_CATALOG USER_DEFINED_TYPE_NAME USER_DEFINED_TYPE_SCHEMA USING VACUUM VALID VALIDATOR VALUE VALUES VARCHAR VARIABLE VARYING VERBOSE VERSION VIEW VOLATILE WHEN WHENEVER WHERE WITH WITHOUT WORK WRITE YEAR ZONE

Language features

Feature Supported Example Token
Booleans TRUE FALSE
Strings '
MultiLine Comments
/* A comment
*/
/* */
Comments
-- A comment
Line Comments
-- A comment
--
Semantic Indentation ϴ

Books about PostgreSQL on goodreads

title author year reviews ratings rating
PostgreSQL Developer's Handbook Ewald Geschwinde 2001 0 6 3.17
PostgreSQL Server Programming Hannu Krosing 2012 3 15 3.87
PostgreSQL Developer's Guide Ibrar Ahmed 2015 2 8 3.75

Books about PostgreSQL from ISBNdb

title authors year publisher
PHP and PostgreSQL Advanced Web Programming Geschwinde, Ewald and Schoenig, Hans-Juergen 2002 Sams Publishing
PostgreSQL Server Programming Hannu Krosing and Kirk Roybal and Jim Mlodgenski 2013 Packt Publishing
PostgreSQL Development Essentials Manpreet Kaur and Baji Shaik 2016-09-26 Packt Publishing
Beginning PostgreSQL on the Cloud: Simplifying Database as a Service on Cloud Platforms Shaik, Baji and Vallarapu, Avinash 2018 Apress
PostgreSQL 9.0 Official Documentation - Volume III. Server Programming Postgresql Global Development Group and The Postgresql Global Development Group 2011 Fultus Corporation
PostgreSQL Server Programming - Second Edition Dar, Usama and Krosing, Hannu and Mlodgenski, Jim and Roybal, Kirk 2015 Packt Publishing
Postgresql 9.5 Vol4: Server Programming (volume 4) Postgresql Development Group 2016 Samurai Media Limited
Postgresql 9.6 Vol4: Server Programming (volume 4) Postgresql Development Group 2017 Samurai Media Limited
PostgreSQL Configuration: Best Practices for Performance and Security Shaik, Baji 2020 Apress
Practical PostgreSQL Drake, Joshua D. and Worsley, John C. 2002 O'Reilly Media
PostgreSQL Douglas, Korry 2005 Sams Publishing
PostgreSQL 9.0 High Performance Smith, Gregory 2010 Packt Publishing
Learning PostgreSQL 10 - Second Edition: A beginner's guide to building high-performance PostgreSQL database solutions Juba, Salahaldin and Volkov, Andrey 2017 Packt Publishing
Learning PostgreSQL: Create, develop and manage relational databases in real world applications using PostgreSQL Juba, Salahaldin and Vannahme, Achim and Volkov, Andrey 2015 Packt Publishing
PostgreSQL 11 Server Side Programming Quick Start Guide: Effective database programming and interaction Ferrari, Luca 2018 Packt Publishing
PostgreSQL Server Programming - Second Edition Dar, Usama and Krosing, Hannu and Mlodgenski, Jim and Roybal, Kirk 2015 Packt Publishing
PostgreSQL 11 Server Side Programming Quick Start Guide: Effective database programming and interaction Ferrari, Luca 2018 Packt Publishing
Beginning PHP and PostgreSQL E-Commerce: From Novice to Professional (Beginning, from Novice to Professional) Darie, Cristian and Bucica, Mihai and Balanescu, Emilian 2006 Apress
PostgreSQL 8.4 Official Documentation - Volume III. Server Programming The PostgreSQL Global Development Group 2009 Fultus Corporation
Learn PyQt The Hard Way: A Quick Start Guide to PostgreSQL and SQLite Driven Programming Siahaan, Vivian and Sianipar, Rismon Hasiholan 2019 Independently published
Practical PostgreSQL Joshua D. Drake; John C. Worsley 20020107 O'Reilly Media, Inc.
Practical PostgreSQL Joshua D. Drake 20020107 O'Reilly Media, Inc.
Learning PostgreSQL Salahaldin Juba 30-11-2015 Packt Publishing
Learn PostgreSQL Luca Ferrari; Enrico Pirozzi 44113 Packt Publishing
Postgresql Programmer's Guide Thomas Lockhart 2000 Iuniverse Inc
PostgreSQL Replication Zoltan Boszormenyi and Hans-Jurgen Schonig 2013-08-26 Packt Publishing
PostgreSQL Server Programming Hannu Krosing; Kirk Roybal; Jim Mlodgenski 20130625 Packt Publishing
PostgreSQL Query Optimization Henrietta Dombrovskaya; Boris Novikov; Anna Bailliekova 20210422 Springer Nature
PostgreSQL Development Essentials Manpreet Kaur 26-09-2016 Packt Publishing
Learning PostgreSQL 11 Salahaldin Juba; Andrey Volkov 31-01-2019 Packt Publishing
PostgreSQL Developer's Guide Ahmed Ibrar 20150227 Packt Publishing
Postgresql 9.4 Vol4: Server Programming Postgresql Development Group 2015 Samurai Media Limited
Beginning PHP and PostgreSQL 8 W Jason Gilmore; Robert H. Treat 20061121 Springer Nature
Developing Modern Database Applications with PostgreSQL Dr. Quan Ha Le; Marcelo Diaz 13-08-2021 Packt Publishing
Postgresql 10 Vol4: Server Programming (volume 4) Postgresql Development Group 2017-10-26 Samurai Media Limited
The Postgresql Reference Manual Volume 2: Programming Guide The Postgresql Global Development Group 2007 Network Theory Ltd.
Postgresql 9.0 Reference Manual - Volume 2: Programming Guide Postgresql Global Development Group 2010 Network Theory Ltd.

Publications about PostgreSQL from Semantic Scholar

title authors year citations influentialCitations
Implementasi JSON untuk Minimasi Penggunaan Jumlah Kolom Suatu Tabel Pada Database PostgreSQL M. A. Rosid 2017 5 1
Penerapan Replikasi Data pada Aplikasi Ticketing Menggunakan Slony PostgreSQL Defriyanuar Dhining and Yeni Rokhayati and D. Kurniawan 2017 4 0
Query compilation in PostgreSQL by specialization of the DBMS source code E. Sharygin and R. Buchatskiy and Roman Zhuykov and A. Sher 2017 2 0
haskell.html · postgresql.html · lisp.html

View source

PLDB - Build the next great programming language · v2022 · Day 33 · Docs · Build · Acknowledgements · Traffic Today · Traffic Trends · Mirrors · GitHub · feedback@pldb.com