PostgreSQL (/ˌpoʊstɡrɛskjuˈɛl/ POHST-gres-kew-EL) also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing...
103 KB (8,668 words) - 19:59, 15 June 2025
Language SQL—Part 2: Foundation (SQL/Foundation). 1999. "PostgreSQL server programming". PostgreSQL 9.1 official documentation. postgresql.org. 2011...
45 KB (4,046 words) - 07:38, 24 June 2025
"pgcrypto". PostgreSQL: Documentation: 9.6. PostgreSQL Global Development Group. 12 August 2021. "Section 13.20 Miscellaneous Functions". MySQL 5.7 Reference...
38 KB (4,601 words) - 10:29, 1 July 2025
commas." "Documentation: 14: COPY". PostgreSQL. Retrieved 2024-05-12. "Documentation: 14: F.35. postgres_fdw". PostgreSQL. 2022-02-10. Retrieved 2022-03-04...
33 KB (4,004 words) - 20:03, 1 July 2025
Data definition language (redirect from Drop (SQL))
(Transact-SQL)". Microsoft Docs. Microsoft. Retrieved 12 November 2018. "PostgreSQL Transactions". PostgreSQL 8.3 Documentation. PostgreSQL. 7 February...
9 KB (1,002 words) - 19:09, 27 November 2024
2011. "Developer FAQ - PostgreSQL wiki". wiki.postgresql.org. "Chapter 18. Installation from Source Code on Windows". PostgreSQL Documentation. 29 September...
17 KB (2,063 words) - 11:23, 13 June 2025
LAMP (software bundle) (redirect from Linux, Apache, MySQL, PHP)
the more lightweight web server Nginx. A version where MySQL has been replaced by PostgreSQL is called LAPP, or sometimes by keeping the original acronym...
16 KB (1,657 words) - 18:16, 11 June 2025
Microsoft SQL Server 2008: T-SQL Programming (Microsoft Press) Jeroen Coussement, "Replacing EAV with JSONB in PostgreSQL" (2016) Postgres 9.6, "JSON...
66 KB (9,767 words) - 04:32, 15 June 2025
considerably), EnterpriseDB (a fork of PostgreSQL, adding Oracle compatibility features), Supported PostgreSQL with their proprietary ESM storage system...
17 KB (1,971 words) - 12:01, 12 May 2025
Database trigger (redirect from SQL trigger)
"DDL Events - SQL Server". 15 March 2023. "PostgreSQL: Documentation: 9.0: CREATE TRIGGER". www.postgresql.org. 8 October 2015. MySQL 5.0 Reference Manual...
19 KB (2,443 words) - 08:33, 30 January 2025
DATACOM/DB 11, IBM DB2, SAP SQL Anywhere, PostgreSQL, EffiProz, H2, HSQLDB version 2.0, Oracle 12c and Mimer SQL. Microsoft SQL Server 2008 and higher supports...
33 KB (3,100 words) - 20:59, 25 January 2025
SQL-92 to SQL:2016: Standard SQL Reserved Words Summary. "Appendix C. SQL Key Words". PostgreSQL documentation. The PostgreSQL Global Development Group....
113 KB (179 words) - 16:43, 16 April 2025
Comparison of relational database management systems (redirect from Comparison of SQL database management systems)
DDL in PostgreSQL: A Competitive Analysis - PostgreSQL wiki". wiki.postgresql.org. "[MDEV-4259] transactional DDL - Jira". jira.mariadb.org. "SQL Server...
144 KB (3,650 words) - 13:43, 9 June 2025
> 1; PostgreSQL 16.1 Documentation (PDF). The PostgreSQL Global Development Group. 2023. Retrieved February 8, 2024. The HAVING and GROUP BY SQL clauses...
3 KB (312 words) - 20:58, 25 January 2025
Database (section 2000s, NoSQL and NewSQL)
lessons from INGRES to develop a new database, Postgres, which is now known as PostgreSQL. PostgreSQL is often used for global mission-critical applications...
78 KB (9,882 words) - 16:36, 29 June 2025
blog.twitter.com. Retrieved 3 April 2020. SQL: This includes MySQL, PostgreSQL and Vertica. MySQL/PosgreSQL are used where we need strong consistency...
69 KB (6,514 words) - 09:07, 22 May 2025
Postgres-XL is a distributed relational database management system (RDBMS) software based on PostgreSQL. It aims to provide feature parity with PostgreSQL...
6 KB (440 words) - 04:42, 9 May 2025
Leo; Obe, Regina (May 18, 2008). "Cross Compare of SQL Server, MySQL, and PostgreSQL". Postgres OnLine Journal. Retrieved 8 October 2010. Chodorow, Kristina;...
10 KB (1,014 words) - 21:05, 31 March 2025
Retrieved 2025-01-23. "PostgreSQL Release 8.4". www.postgresql.org. 24 July 2014. Retrieved 2024-03-10. "MySQL :: What's New in MySQL 8.0? (Generally Available)"...
9 KB (897 words) - 00:25, 5 February 2025
written in C and extends PostgreSQL. TimescaleDB is a relational database and supports standard SQL queries. Additional SQL functions and table structures...
8 KB (724 words) - 22:28, 17 June 2025
from this page "UPDATE". January 2012. "SQL - Update a table column, then the other column with updated value of the former. MySQL / PostgreSQL differ"....
5 KB (596 words) - 20:59, 25 January 2025
apps". Macworld. Retrieved September 28, 2021. "PostgreSQL: Documentation: 9.2: tablefunc". postgresql.org. November 9, 2017. "CONNECT Table Types – PIVOT...
20 KB (2,106 words) - 16:55, 9 May 2025
Boolean data type (section SQL)
Archived 2005-03-09 at the Wayback Machine "PostgreSQL: Documentation: 10: 8.6. Boolean Type". www.postgresql.org. Archived from the original on 9 March...
26 KB (3,134 words) - 02:19, 29 April 2025
the ISO SQL standard many DBMS vendors treat this operation similarly. For instance, the Oracle, PostgreSQL, MySQL Server, and Microsoft SQL Server platforms...
61 KB (7,610 words) - 11:03, 4 May 2025
PL/pgSQL (Procedural Language/PostgreSQL) is a procedural programming language supported by the PostgreSQL ORDBMS. It closely resembles Oracle's PL/SQL language...
8 KB (550 words) - 12:23, 26 March 2025
Microsoft SQL Server (since SQL Server 2008 R2), Firebird 2.1, PostgreSQL 8.4+, SQLite 3.8.3+, IBM Informix version 11.50+, CUBRID, MariaDB 10.2+ and MySQL 8...
14 KB (1,375 words) - 17:14, 30 May 2025
Apache Drill - A MPP SQL query engine for querying large datasets. Drill supports spatial data types and functions similar to PostgreSQL. Esri Geodatabase...
22 KB (2,041 words) - 12:04, 3 May 2025
PostgreSQL, Oracle and MySQL) and ROUND (Informix, SQLite, Sybase, Oracle, PostgreSQL, Microsoft SQL Server and Mimer SQL.)) Temporal (datetime) DATE:...
35 KB (3,960 words) - 20:43, 24 May 2025
officially supports five database backends: PostgreSQL, MySQL, MariaDB, SQLite, and Oracle. Microsoft SQL Server can be used with mssql-django. The Django...
34 KB (2,172 words) - 14:29, 19 May 2025