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...
102 KB (8,624 words) - 00:01, 19 December 2024
Language SQL—Part 2: Foundation (SQL/Foundation). 1999. "PostgreSQL server programming". PostgreSQL 9.1 official documentation. postgresql.org. 2011...
40 KB (3,767 words) - 06:46, 20 December 2024
Multi-master replication (section PostgreSQL)
Mozilla Public License, and PostgresXC (now known as Postgres-X2) which is available under the same license as PostgreSQL itself are examples. Note that...
16 KB (1,871 words) - 21:29, 3 January 2024
"pgcrypto". PostgreSQL: Documentation: 9.6. PostgreSQL Global Development Group. 12 August 2021. "Section 13.20 Miscellaneous Functions". MySQL 5.7 Reference...
37 KB (4,529 words) - 23:17, 9 December 2024
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...
17 KB (1,699 words) - 23:46, 7 December 2024
commas." "Documentation: 14: COPY". PostgreSQL. Retrieved 2024-05-12. "Documentation: 14: F.35. postgres_fdw". PostgreSQL. 2022-02-10. Retrieved 2022-03-04...
31 KB (3,839 words) - 23:36, 21 December 2024
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,340 words) - 06:41, 3 April 2024
EnterpriseDB (redirect from Postgres Plus Standard Server)
based on the open-source database PostgreSQL (also known as Postgres), and is one of the largest contributors to Postgres. EDB develops and integrates performance...
13 KB (1,028 words) - 10:22, 21 September 2024
Materialized view (category Articles with example SQL code)
"Materialized Views - PostgreSQL wiki". wiki.postgresql.org. Retrieved 29 November 2022. "CREATE MATERIALIZED VIEW". PostgreSQL Documentation. 10 November...
11 KB (1,228 words) - 04:06, 17 October 2024
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
Block Range Index (category PostgreSQL)
particular vendors. So far PostgreSQL is the only vendor to have announced a live product with this specific feature, in PostgreSQL 9.5. Other vendors have...
15 KB (1,709 words) - 18:45, 23 August 2024
the ISO SQL standard many DBMS vendors treat this operation similarly. For instance, the Oracle, PostgreSQL, MySQL Server, and Microsoft SQL Server platforms...
62 KB (7,599 words) - 15:49, 7 November 2024
considerably), EnterpriseDB (a fork of PostgreSQL, adding Oracle compatibility features), Supported PostgreSQL with their proprietary ESM storage system...
17 KB (1,884 words) - 10:40, 5 September 2024
embedded SQL, for example, is called Pro*C in Oracle and Sybase database management systems, ESQL/C in Informix, and ECPG in the PostgreSQL database management...
9 KB (915 words) - 15:28, 19 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,076 words) - 06:22, 15 December 2024
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 (535 words) - 11:51, 5 September 2024
Prepared statement (redirect from Prepare (SQL))
database. MySQL, SQL Server and SQLite use the ? notation, but PostgreSQL uses the $N notation. For example, if you were using PostgreSQL instead you...
16 KB (1,809 words) - 23:33, 12 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,581 words) - 15:48, 12 December 2024
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,013 words) - 23:44, 28 November 2024
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) - 12:18, 30 April 2024
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...
143 KB (3,678 words) - 03:36, 18 December 2024
unstructured data. Cloud SQL – Database as a Service based on MySQL, PostgreSQL and Microsoft SQL Server. Cloud Bigtable – Managed NoSQL database service. Cloud...
49 KB (3,654 words) - 10:52, 14 December 2024
reserved. SQL SQL syntax List of relational database management systems "Appendix C. SQL Key Words". PostgreSQL documentation. The PostgreSQL Global Development...
113 KB (159 words) - 19:00, 22 October 2024
website at Microsoft TechNet Converting DBF to SQL Server PostgreSQL vs SQL Server SQL Server Express DATEPART in SQL Server SQL Server ODBC Driver 17...
61 KB (7,139 words) - 20:00, 26 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) - 00:48, 10 December 2024
bytecode, Julia, Kotlin, LabVIEW's G language, Objective-C, OpenCL, PostgreSQL's SQL and PLpgSQL, Ruby, Rust, Scala, Standard ML, Swift, Xojo, and Zig. The LLVM...
33 KB (3,237 words) - 12:20, 4 December 2024
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,101 words) - 14:25, 30 November 2024
GiST (category PostgreSQL)
cubes The PostgreSQL GiST implementation provides the indexing support for the PostGIS (geographic information system) and the BioPostgres bioinformatics...
5 KB (646 words) - 00:02, 22 January 2022
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,728 words) - 20:45, 19 October 2024