• Thumbnail for PostgreSQL
    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
  • Thumbnail for SQLite
    SQLite (redirect from SQL Lite)
    write-intensive deployments. SQLite uses PostgreSQL as a reference platform. "What would PostgreSQL do" is used to make sense of the SQL standard. One major deviation...
    28 KB (2,811 words) - 05:43, 20 March 2024
  • Thumbnail for Universally unique identifier
    "pgcrypto". PostgreSQL: Documentation: 9.6. PostgreSQL Global Development Group. 12 August 2021. "Section 13.20 Miscellaneous Functions". MySQL 5.7 Reference...
    35 KB (4,179 words) - 03:41, 17 April 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
  • Thumbnail for EnterpriseDB
    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
  • Thumbnail for LAMP (software bundle)
    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
  • 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
  • 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
  • Thumbnail for Comma-separated values
    "Documentation: 14: COPY". PostgreSQL. 2022-02-10. Retrieved 2022-03-04. "Documentation: 14: F.35. postgres_fdw". PostgreSQL. 2022-02-10. Retrieved 2022-03-04...
    30 KB (3,783 words) - 03:19, 26 April 2024
  • (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
  • Thumbnail for PL/pgSQL
    PL/pgSQL (Procedural Language/PostgreSQL) is a procedural programming language supported by the PostgreSQL ORDBMS. It closely resembles Oracle's PL/SQL language...
    7 KB (517 words) - 23:48, 20 June 2023
  • 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
  • Thumbnail for Null (SQL)
    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,601 words) - 13:07, 8 January 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
  • 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
  • Thumbnail for Database
    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
  • 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
  • Thumbnail for OwnCloud
    Vue.js. While ownCloud 10 uses PHP scripts to access an SQLite, MySQL or PostgreSQL database installed on the server, Infinite Scale works without a database...
    20 KB (1,404 words) - 14:39, 18 March 2024