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...
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();
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
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 |
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 |
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. |
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 |