Details

  • PostgreSQL, often simply Postgres, is an open source object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance.

Connecting & Authenticating

  • When configuring PostgreSQL using DatabaseReference[URL["url"]], "url" is typically of the form "postgresql://user:password@host:port/name".
  • In DatabaseReference[assoc], typical elements of assoc include:
  • "Backend"the type of SQL backend used
    "Name"the name of the database
    "Host"the host serving the database
    "Port"the server port through which to access the database
    "Username"the username used to authenticate the database
    "Password"the password used to authenticate the database

Supported Types

Examples

Basic Examples  (1)

Create a PostgreSQL connection using the URL wrapper:

The canonical form of a DatabaseReference for PostgreSQL uses Association:

Introduced in 2020
 (12.1)