WPS Engine for PostgreSQL

Data Engine Modules

Home 5 Products 5 Information 5 SAS language 5 Data engine modules 5 WPS Engine for PostgreSQL

PostgreSQL Database Connectivity

The WPS Engine for PostgreSQL module provides connectivity to version 9 (and upwards) of the PostgreSQL database.

Type of Access	Supported?
Reading
Writing
Updating
Creating New Tables
Implicit Pass Through Support
Explicit Pass Through Support
Bulk Loading

The WPS engine for PostgreSQL connects to a PostgreSQL database using PostgreSQL’s own libpq API

Dependencies and Usage

The WPS Engine for PostgreSQL can only be used on the supported platforms indicated in the table below.

Platform	Supported?
AIX on IBM Power
Linux on ARM
Linux on IBM Power LE (Little Endian)
Linux on x86
macOS on x86
Windows on x86
z/OS on an architecture 7 machine

Other data engine modules

WPS Engine for Actian Matrix

Library engine for accessing an Actian Matrix database

WPS Engine for DB Files

Library engines and procedures for accessing Access, Excel, SPSS and dBase files

WPS Engine for DB2

Library engines and procedures for accessing a DB2 database

WPS Engine for Greenplum

Library engines for accessing a Greenplum warehouse

WPS Engine for Hadoop

Library engines for accessing a Hadoop warehouse

WPS Engine for Informix

Library engines for accessing an Informix database

WPS Engine for Kognitio

Library engines for accessing a kognitio warehouse

WPS Engine for MySQL

Library engines for accessing a MySQL database

WPS Engine for MariaDB

Library engines for accessing a MariaDB database

WPS Engine for Netezza

Library engines for accessing a Netezza appliance

WPS Engine for ODBC

Library engines for accessing ODBC datasources

WPS Engine for OLEDB

Library engines for accessing OLEDB datasources

WPS Engine for Oracle

Library engines for accessing an Oracle database