Enable JavaScript to interact with content and submit forms on Wolfram websites. Learn how

"PostgreSQL"

Listing of Supported Databases »

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

	BOOLEAN	True or False
	BYTEA	ByteArray
	DATE	DateObject with Day granularity
	TIMESTAMP	DateObject with Instant granularity and time zone support
	NUMERIC	Real with fixed precision
	BIGINT, INTEGER, SMALLINT	Integer
	DOUBLE_PRECISION, FLOAT, REAL	Real
	CHAR, TEXT, VARCHAR	String
	TIME	TimeObject

Examples

Basic Examples (1)

Create a PostgreSQL connection using the URL wrapper:

The canonical form of a DatabaseReference for PostgreSQL uses Association:

Top