PostgreSQL (/ˈpoʊstɡrɛs ˌkjuː ˈɛl/, POHST-gres kyoo el), also known as Postgres, is a free and open-source relational database management system (RDBMS)... 98 KB (8,582 words) - 05:36, 18 April 2024 |
Language SQL—Part 2: Foundation (SQL/Foundation). 1999. "PostgreSQL server programming". PostgreSQL 9.1 official documentation. postgresql.org. 2011... 39 KB (3,760 words) - 22:44, 19 April 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) - 11:04, 3 January 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 |
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,219 words) - 01:19, 11 October 2023 |
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... 12 KB (1,020 words) - 21:02, 12 April 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,660 words) - 09:25, 11 April 2024 |
Comparison of relational database management systems (redirect from Comparison of SQL database management systems) Enea AB "PostgreSQL: Documentation: IMPORT FOREIGN SCHEMA". www.postgresql.org. Retrieved 2016-06-11. Wikibooks has a book on the topic of: SQL dialects... 138 KB (3,362 words) - 04:42, 19 April 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 |
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 (961 words) - 23:22, 26 January 2023 |
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 (907 words) - 04:22, 5 December 2023 |
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,126 words) - 06:10, 27 April 2024 |
Julia, Kotlin, LabVIEW's G language, Lua, Objective-C, OpenCL, PostgreSQL's SQL and PLpgSQL, Ruby, Rust, Scala, Swift, Xojo, and Zig. The LLVM project started... 32 KB (3,171 words) - 01:18, 19 March 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) - 09:15, 16 October 2023 |
Amazon Aurora (section MySQL compatibility) Database Service (RDS). Aurora offered MySQL compatible service upon its release in 2014. It added PostgreSQL compatibility in October 2017. In August... 7 KB (623 words) - 02:08, 17 April 2024 |
com. "Developer FAQ - PostgreSQL wiki". wiki.postgresql.org. "Chapter 18. Installation from Source Code on Windows". PostgreSQL Documentation. 29 September... 16 KB (2,056 words) - 13:19, 26 April 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,535 words) - 08:19, 1 April 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) - 12:39, 31 March 2024 |
unstructured data. Cloud SQL – Database as a Service based on MySQL, PostgreSQL and Microsoft SQL Server. Cloud Bigtable – Managed NoSQL database service. Cloud... 48 KB (3,481 words) - 01:06, 20 April 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... 27 KB (2,985 words) - 23:23, 6 March 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 |
considerably), EnterpriseDB (a fork of PostgreSQL, adding Oracle compatibility features), Supported PostgreSQL with their proprietary ESM storage system... 17 KB (1,865 words) - 08:13, 25 April 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,102 words) - 19:30, 20 March 2024 |
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) - 09:28, 4 April 2024 |