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.
All labels observed (21)
Statements (79)
| Predicate | Object |
|---|---|
| instanceOf |
object-relational database management system
ⓘ
open-source software ⓘ relational database management system ⓘ |
| developer |
PostgreSQL
self-linksurface differs
ⓘ
surface form:
PostgreSQL Global Development Group
|
| hasReleaseModel |
major release every year
ⓘ
minor release every quarter ⓘ |
| initialReleaseDate | 1996-01-29 ⓘ |
| license |
BSD license
ⓘ
surface form:
PostgreSQL License
|
| operatingSystem |
FreeBSD
ⓘ
Linux ⓘ OpenBSD ⓘ Solaris operating system ⓘ
surface form:
Solaris
Windows ⓘ macOS ⓘ |
| originatesFrom |
PostgreSQL
self-linksurface differs
ⓘ
surface form:
POSTGRES project
|
| originatesFromInstitution | University of California, Berkeley ⓘ |
| programmingLanguage | C ⓘ |
| supportsAuthentication |
GSSAPI
ⓘ
LDAP ⓘ SMB ⓘ
surface form:
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 ⓘ GiST ⓘ
surface form:
SP-GiST
|
| supportsLanguage |
Perl
ⓘ
surface form:
PL/Perl
PL/Python ⓘ PL/Tcl ⓘ PL/pgSQL ⓘ |
| supportsProtocol |
JDBC
ⓘ
ODBC ⓘ client-server model ⓘ PostgreSQL self-linksurface differs ⓘ
surface form:
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 (80)
Full triples — surface form annotated when it differs from this entity's canonical label.
this entity surface form:
PostgreSQL Global Development Group
this entity surface form:
POSTGRES project
this entity surface form:
libpq
this entity surface form:
PostgreSQL (via providers)
this entity surface form:
PostgreSQL databases
subject surface form:
IBM Db2
this entity surface form:
Postgres
subject surface form:
Google Data Studio
subject surface form:
Vapor
this entity surface form:
PostgreSQL triggers
this entity surface form:
PostgreSQL trigger manager
this entity surface form:
PostgreSQL array types
this entity surface form:
PostgreSQL composite types
this entity surface form:
PostgreSQL official documentation
this entity surface form:
PostgreSQL Global Development Group
this entity surface form:
PostgreSQL Global Development Group
this entity surface form:
PostgreSQL 7.1
this entity surface form:
PostgreSQL core