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,667 words) - 23:09, 8 May 2025
Language SQL—Part 2: Foundation (SQL/Foundation). 1999. "PostgreSQL server programming". PostgreSQL 9.1 official documentation. postgresql.org. 2011...
45 KB (4,009 words) - 10:38, 28 April 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,582 words) - 17:57, 1 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
commas." "Documentation: 14: COPY". PostgreSQL. Retrieved 2024-05-12. "Documentation: 14: F.35. postgres_fdw". PostgreSQL. 2022-02-10. Retrieved 2022-03-04...
32 KB (3,969 words) - 06:56, 15 May 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,654 words) - 06:12, 16 May 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
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
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) - 22:25, 18 May 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) - 12:12, 16 March 2025
2011. "Developer FAQ - PostgreSQL wiki". wiki.postgresql.org. "Chapter 18. Installation from Source Code on Windows". PostgreSQL Documentation. 29 September...
17 KB (2,078 words) - 14:14, 5 May 2025
Tom Lane (computer scientist) (section PostgreSQL)
version of PostgreSQL named Red Hat Database. The Red Hat Database project was later cancelled, but Lane continued to work there to develop PostgreSQL. Between...
12 KB (1,103 words) - 02:51, 1 January 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
considerably), EnterpriseDB (a fork of PostgreSQL, adding Oracle compatibility features), Supported PostgreSQL with their proprietary ESM storage system...
17 KB (1,984 words) - 12:01, 12 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
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
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
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
Stored procedure (section Comparison with static SQL)
in MySQL FAQ An overview of PostgreSQL Procedural Language support Using a stored procedure in Sybase ASE PL/SQL Procedures Oracle Database PL/SQL Language...
12 KB (1,298 words) - 23:08, 5 November 2024
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) - 19:04, 15 May 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,377 words) - 10:03, 28 December 2024
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...
75 KB (9,580 words) - 06:27, 16 May 2025
List of unit testing frameworks (section PostgreSQL)
PostgreSQL". Sourceforge.net. 22 March 2013. Retrieved 2019-04-30. "dkLab: Constructor: PGUnit: stored procedures unit-test framework for PostgreSQL 8...
188 KB (6,802 words) - 08:28, 5 May 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
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:59, 25 January 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
> 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
the standard tools found in ArcGIS, and interface with PostgreSQL/PostGIS, SpatiaLite and MySQL databases. QGIS is built on top of, and standard installs...
10 KB (908 words) - 14:12, 27 March 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