Languages Features Creators CSV Resources Challenges Add Language
GitHub icon

PostgreSQL

PostgreSQL - Query language

< >

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

#24on PLDB 37Years 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!';
-- 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 BITLENGTH BLOB BOOLEAN BOTH BREADTH BY CACHE CALL CALLED CARDINALITY CASCADE CASCADED CASE CAST CATALOG CATALOGNAME CHAIN CHAR CHARACTER CHARACTERISTICS CHARACTERLENGTH CHARACTERSETCATALOG CHARACTERSETNAME CHARACTERSETSCHEMA CHARLENGTH CHECK CHECKED CHECKPOINT CLASS CLASSORIGIN CLOB CLOSE CLUSTER COALESCE COBOL COLLATE COLLATION COLLATIONCATALOG COLLATIONNAME COLLATIONSCHEMA COLUMN COLUMNNAME COMMANDFUNCTION COMMANDFUNCTIONCODE COMMENT COMMIT COMMITTED COMPLETION CONDITIONNUMBER CONNECT CONNECTION CONNECTIONNAME CONSTRAINT CONSTRAINTS CONSTRAINTCATALOG CONSTRAINTNAME CONSTRAINTSCHEMA CONSTRUCTOR CONTAINS CONTINUE CONVERSION CONVERT COPY CORRESPONDING COUNT CREATE CREATEDB CREATEUSER CROSS CUBE CURRENT CURRENTDATE CURRENTPATH CURRENTROLE CURRENTTIME CURRENTTIMESTAMP CURRENTUSER CURSOR CURSORNAME CYCLE DATA DATABASE DATE DATETIMEINTERVALCODE DATETIMEINTERVALPRECISION 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 DYNAMICFUNCTION DYNAMICFUNCTIONCODE 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 KEYMEMBER KEYTYPE 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 MESSAGELENGTH MESSAGEOCTETLENGTH MESSAGETEXT 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 OCTETLENGTH 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 PARAMETERMODE PARAMETERNAME PARAMETERORDINALPOSITION PARAMETERSPECIFICCATALOG PARAMETERSPECIFICNAME PARAMETERSPECIFICSCHEMA 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 RETURNEDLENGTH RETURNEDOCTETLENGTH RETURNEDSQLSTATE RETURNS REVOKE RIGHT ROLE ROLLBACK ROLLUP ROUTINE ROUTINECATALOG ROUTINENAME ROUTINESCHEMA ROW ROWS ROWCOUNT RULE SAVEPOINT SCALE SCHEMA SCHEMANAME SCOPE SCROLL SEARCH SECOND SECTION SECURITY SELECT SELF SENSITIVE SEQUENCE SERIALIZABLE SERVERNAME SESSION SESSIONUSER SET SETOF SETS SHARE SHOW SIMILAR SIMPLE SIZE SMALLINT SOME SOURCE SPACE SPECIFIC SPECIFICTYPE SPECIFICNAME SQL SQLCODE SQLERROR SQLEXCEPTION SQLSTATE SQLWARNING STABLE START STATE STATEMENT STATIC STATISTICS STDIN STDOUT STORAGE STRICT STRUCTURE STYLE SUBCLASSORIGIN SUBLIST SUBSTRING SUM SYMMETRIC SYSID SYSTEM SYSTEMUSER TABLE TABLENAME TEMP TEMPLATE TEMPORARY TERMINATE THAN THEN TIME TIMESTAMP TIMEZONEHOUR TIMEZONEMINUTE TO TOAST TRAILING TRANSACTION TRANSACTIONSCOMMITTED TRANSACTIONSROLLEDBACK TRANSACTIONACTIVE TRANSFORM TRANSFORMS TRANSLATE TRANSLATION TREAT TRIGGER TRIGGERCATALOG TRIGGERNAME TRIGGERSCHEMA TRIM TRUE TRUNCATE TRUSTED TYPE UNCOMMITTED UNDER UNENCRYPTED UNION UNIQUE UNKNOWN UNLISTEN UNNAMED UNNEST UNTIL UPDATE UPPER USAGE USER USERDEFINEDTYPECATALOG USERDEFINEDTYPENAME USERDEFINEDTYPE_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 Token Example
Booleans ✓ TRUE FALSE
Strings ✓ '
Case Insensitive Identifiers ✓
MultiLine Comments ✓ /* */
/* A comment
*/
Comments ✓
-- A comment
Line Comments ✓ --
-- A comment
Semantic Indentation X

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
swift.html · postgresql.html · kotlin.html

View source

- Build the next great programming language · Search · Day 214 · About · Blog · Acknowledgements · Traffic · Traffic Today · GitHub · feedback@pldb.com