PostgreSQL

E17669

object-relational database management system open-source software relational database management system

PostgreSQL is a powerful open-source relational database management system known for its robustness, extensibility, and strong standards compliance.

Aliases (16)

Statements (79)

Predicate	Object
instanceOf	object-relational database management system → open-source software → relational database management system →
developer	PostgreSQL Global Development Group →
hasReleaseModel	major release every year → minor release every quarter →
initialReleaseDate	1996-01-29 →
license	PostgreSQL License →
operatingSystem	FreeBSD → Linux → OpenBSD → Solaris → Windows → macOS →
originatesFrom	POSTGRES project →
originatesFromInstitution	University of California, Berkeley →
programmingLanguage	C →
supportsAuthentication	GSSAPI → LDAP → SSPI → certificate-based authentication → password authentication →
supportsDataModel	document model via JSON → key-value model via hstore → relational model →
supportsExtension	PostGIS → ltree → pg_stat_statements → pg_trgm → uuid-ossp →
supportsFeature	JSON data type → MVCC → XML data type → array data type → common table expressions → constraints → extensions → foreign keys → full-text search → hstore key-value store → logical replication → materialized views → partitioning → pluggable procedural languages → point-in-time recovery → stored procedures → streaming replication → tablespaces → triggers → user-defined data types → user-defined functions → views → window functions → write-ahead logging →
supportsIndexType	B-tree → BRIN → GIN → GiST → Hash → SP-GiST →
supportsLanguage	PL/Perl → PL/Python → PL/Tcl → PL/pgSQL →
supportsProtocol	JDBC → ODBC → client-server model → libpq →
supportsReplicationMode	asynchronous replication → synchronous replication →
supportsSecurityFeature	SSL/TLS connections → role-based access control → row-level security →
supportsStandard	ACID → SQL →
supportsTransactionIsolationLevel	READ COMMITTED → REPEATABLE READ → SERIALIZABLE →
website	https://www.postgresql.org/ →

Referenced by (36)

Subject (surface form when different)	Predicate
Django → Entity Framework ("PostgreSQL (via providers)") → PHP → Vapor →	supportsDatabase
BRIN → GiST → PostGIS ("PostgreSQL ecosystem") →	partOf
PL/Python ("PostgreSQL trigger manager") → Tableau →	integratesWith
PL/Python ("PostgreSQL Global Development Group") → PL/Tcl ("PostgreSQL Global Development Group") →	maintainedBy
PL/Python ("PostgreSQL array types") → PL/Python ("PostgreSQL composite types") →	mapsToPythonTypeSystem
PL/Tcl → PL/pgSQL ("PostgreSQL server") →	runsOn
AppSheet ("PostgreSQL databases") → Google Data Studio →	supportsDataSource
IANA time zone database → Olson database →	usedBy
PL/Python ("PostgreSQL triggers") →	allowsWriting
IBM Db2 →	competesWith
PL/pgSQL →	designedFor
PostgreSQL ("PostgreSQL Global Development Group") →	developer
PL/Python ("PostgreSQL official documentation") →	documentationLocation
open-source movement →	hasNotableProject
Data Control Language →	implementedBy
BRIN ("PostgreSQL core") →	implementedIn
INGRES relational database system ("Postgres") →	influenced
GiST ("PostgreSQL 7.1") →	introducedIn
Transparent Data Encryption →	isImplementedIn
ACM Software System Award →	notableRecipient
PostgreSQL ("POSTGRES project") →	originatesFrom
PL/Python →	supportsDatabaseSystem
PostgreSQL ("libpq") →	supportsProtocol
SQL →	usedBySystem
GiST ("PostgreSQL database system") →	usedIn