"PostgreSQL"

Details

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

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

	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

Create a PostgreSQL connection using the URL wrapper:

In[1]:=1

✖

https://wolfram.com/xid/0eyho47557ydokqi4ebxs49apckejhib-pz4mps

The canonical form of a DatabaseReference for PostgreSQL uses Association:

In[2]:=2

✖

https://wolfram.com/xid/0eyho47557ydokqi4ebxs49apckejhib-73jerz

Top