Libname Options Access to Postgres for SAS9.4M8

[Markus04]

Hello everyone,

at the moment it is not possible to use libname options (for example BULKUNLOAD ) for the Postgres engine in SAS 9.4. This is a major issue for the effective use of Postgres in a SAS 9.4environment.

Enhancing the interface would be very helpful in enabling Postgres to be used in a way similar to DB2. Otherwise, we are missing the integration of a widely used Database Management System.

Thanks in advance.

[AhmedAl_Attar]

@Markus04 

Are you sure?
According to the on-line docs https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n0sc92audsisvsn1jbd0fx3nealw.htm

SAS/ACCESS Interface to Postgres supports bulk loading!

[Markus04]

Hello @AhmedAl_Attar ,

thanks for your comment.

It is possible to use BULKUNLOAD in the proc sql statement like that:

PROC SQL;

CREATE TABLE WORK.TEST1 AS

SELECT KEY_VERTRAG,

ZUSTAND

FROM WL02ZUGR.znw (bulkunload=yes)

WHERE 

...

However, it is not possible to use the BULKUNLOAD statement as an libname option:

libname test postgres server=test1 DATABASE=test PORT=50146 SCHEMA=test User=USER password="XXX" BULKUNLOAD=YES CONOPTS="UseDeclarefetch=1";