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.

Try in SPARQL Jump to: Surface forms Disambiguation Statements Elicitation Referenced by
AI illustration

How this image was made

AI-generated illustration of PostgreSQL

This AI-generated illustration was produced by black-forest-labs/FLUX.2-dev (1024x1024) from a prompt written by openai/gpt-oss-120b from the entity's label + description.

Prompt

Generate an image of PostgreSQL (PostgreSQL is a powerful open-source relational database management system known for its robustness, extensibility, and strong standards compliance.)

All labels observed (25)

Label Occurrences
PostgreSQL canonical 115
PostgreSQL Global Development Group 3
PostgreSQL server 2

How this entity was disambiguated

Statements (79)

Predicate Object
instanceOf object-relational database management system ⓘ
open-source software ⓘ
relational database management system ⓘ
developer PostgreSQL Global Development Group ⓘ
linked to: PostgreSQL
hasReleaseModel major release every year ⓘ
minor release every quarter ⓘ
initialReleaseDate 1996-01-29 ⓘ
license PostgreSQL License ⓘ
linked to: BSD license
operatingSystem FreeBSD ⓘ
Linux ⓘ
OpenBSD ⓘ
Solaris ⓘ
linked to: Solaris operating system

Windows ⓘ
macOS ⓘ
originatesFrom POSTGRES project ⓘ
linked to: PostgreSQL
originatesFromInstitution University of California, Berkeley ⓘ
programmingLanguage C ⓘ
supportsAuthentication GSSAPI ⓘ
LDAP ⓘ
SSPI ⓘ
linked to: SMB

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 ⓘ
linked to: GiST
supportsLanguage PL/Perl ⓘ
linked to: Perl

PL/Python ⓘ
PL/Tcl ⓘ
PL/pgSQL ⓘ
supportsProtocol JDBC ⓘ
ODBC ⓘ
client-server model ⓘ
libpq ⓘ
linked to: PostgreSQL
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/ ⓘ

How these facts were elicited

Referenced by (143)

Full triples — surface form annotated when it differs from this entity's canonical label.

Tableau → integratesWith → PostgreSQL ⓘ
IANA time zone database → usedBy → PostgreSQL ⓘ
SQL → usedBySystem → PostgreSQL ⓘ
ACM Software System Award → notableRecipient → PostgreSQL ⓘ
Django → supportsDatabase → PostgreSQL ⓘ
PostgreSQL → developer → PostgreSQL Global Development Group ⓘ
linked to: PostgreSQL
PostgreSQL → originatesFrom → POSTGRES project ⓘ
linked to: PostgreSQL
PostgreSQL → supportsProtocol → libpq ⓘ
linked to: PostgreSQL
PHP → supportsDatabase → PostgreSQL ⓘ
Olson database → usedBy → PostgreSQL ⓘ
Entity Framework → supportsDatabase → PostgreSQL (via providers) ⓘ
linked to: PostgreSQL
AppSheet → supportsDataSource → PostgreSQL databases ⓘ
linked to: PostgreSQL
IBM Db2 → competesWith → PostgreSQL ⓘ
subject linked to: IBM DB2
Data Control Language → implementedBy → PostgreSQL ⓘ
open-source movement → hasNotableProject → PostgreSQL ⓘ
Transparent Data Encryption → isImplementedIn → PostgreSQL ⓘ
INGRES relational database system → influenced → Postgres ⓘ
linked to: PostgreSQL
Google Data Studio → supportsDataSource → PostgreSQL ⓘ
subject linked to: Data Studio
Vapor → supportsDatabase → PostgreSQL ⓘ
subject linked to: Vapor (web framework)
PL/pgSQL → designedFor → PostgreSQL ⓘ
PL/pgSQL → runsOn → PostgreSQL server ⓘ
linked to: PostgreSQL
PL/Python → supportsDatabaseSystem → PostgreSQL ⓘ
PL/Python → allowsWriting → PostgreSQL triggers ⓘ
linked to: PostgreSQL
PL/Python → integratesWith → PostgreSQL trigger manager ⓘ
linked to: PostgreSQL
PL/Python → mapsToPythonTypeSystem → PostgreSQL array types ⓘ
linked to: PostgreSQL
PL/Python → mapsToPythonTypeSystem → PostgreSQL composite types ⓘ
linked to: PostgreSQL
PL/Python → documentationLocation → PostgreSQL official documentation ⓘ
linked to: PostgreSQL
PL/Python → maintainedBy → PostgreSQL Global Development Group ⓘ
linked to: PostgreSQL
PL/Tcl → runsOn → PostgreSQL ⓘ
PL/Tcl → maintainedBy → PostgreSQL Global Development Group ⓘ
linked to: PostgreSQL
GiST → partOf → PostgreSQL ⓘ
GiST → usedIn → PostgreSQL database system ⓘ
linked to: PostgreSQL
GiST → introducedIn → PostgreSQL 7.1 ⓘ
linked to: PostgreSQL
BRIN → partOf → PostgreSQL ⓘ
BRIN → implementedIn → PostgreSQL core ⓘ
linked to: PostgreSQL
PostGIS → developedFor → PostgreSQL ⓘ
PostGIS → partOf → PostgreSQL ecosystem ⓘ
linked to: PostgreSQL
Amazon RDS → supportsDatabaseEngine → PostgreSQL ⓘ
Amazon QuickSight → integratesWith → PostgreSQL ⓘ
Flask-SQLAlchemy → worksWith → PostgreSQL ⓘ
Drupal → supportsDatabase → PostgreSQL ⓘ
Joomla! → usesDatabase → PostgreSQL ⓘ
Laravel → supports → PostgreSQL ⓘ
CakePHP → supportsDatabase → PostgreSQL ⓘ
Looker → integratesWith → PostgreSQL ⓘ
MediaWiki → usesDatabase → PostgreSQL ⓘ
Oracle Data Integrator → supports → PostgreSQL ⓘ
Oracle GoldenGate → supportsDatabase → PostgreSQL ⓘ
Sails.js → supportsDatabase → PostgreSQL ⓘ
Bugzilla → backendDatabase → PostgreSQL ⓘ