Native PostgreSQL Connector for WINDEV and WEBDEV

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / Native Connectors/Native Accesses / Native PostgreSQL Connector

Overview
Required configuration
Requirements for using the PostgreSQL Native Connector
Specific file distributed with Native PostgreSQL Connector
Use
Using Native PostgreSQL Connector in your WINDEV applications and WEBDEV websites

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Native PostgreSQL Connector for WINDEV and WEBDEV

Available only with this kind of connection

Overview

WINDEV and WEBDEV 2025 include a Native PostgreSQL Connector (or Native PostgreSQL Access), available in 32 and 64-bit mode. This Native Connector allows you to access a PostgreSQL database from a WLanguage program without using any external driver.

Attention: This version of the PostgreSQL Native Connector only works with WINDEV and WEBDEV version 2025.

Remarque: The PostgreSQL Native Connector is a free optional module available for download from the PC SOFT site.

Required configuration

Requirements for using the PostgreSQL Native Connector

We recommend that you use a recent PostgreSQL client library, whose version is identical to the version of your server if possible.

To do so, you must:

Copy the DLLs of the PostgreSQL client library to the WINDEV or WEBDEV installation directory on the development computer.
Note: All dependencies delivered with the client library must also be copied.
Copy the DLLs of the PostgreSQL client library to the executable directory or to the Windows directory on the development computer.
Note: It is also necessary to copy all the dependencies delivered with the client library..
Install the DLLs of Visual runtime (package that can be downloaded from Microsoft site).
Note: The version of the visual runtime depends on the PostgreSQL client library.

In 32-bit mode, if these DLLs are not found, the Native PostgreSQL Connector will use a standard client library (PostgreSQL version 7.4.23). It contains all the necessary features for the Native Connector and is compatible with servers up to version 9.6. If you use a server in a more recent version, install a version of the client library compatible with your server.

The PostgreSQL client library should be installed with the Linux distribution package manager. Dependencies will also be installed.
Example (Debian):

apt-get install libpq5

Note: To use SSL connections, you need to install a PostgreSQL client library version 9.1 or higher.

Specific file distributed with Native PostgreSQL Connector

To use Native PostgreSQL Connector:

in 32-bit mode, only the wd300postgresql.DLL DLL is required. This file is provided with the Native PostgreSQL Connector for WINDEV and WEBDEV.
in 64-bit mode, only the wd300postgresql64.DLL DLL is required. This file is provided with the Native PostgreSQL Connector for WINDEV and WEBDEV.

Use

Using Native PostgreSQL Connector in your WINDEV applications and WEBDEV websites

To use PostgreSQL in native mode, you must program in the WINDEV application or in the WEBDEV site:

with the "SQL" functions of WLanguage (see Programming with SQL functions).
with the "HFSQL" functions of WLanguage (see Programming with HFSQL functions).

Remarks:

Don't forget to read the limitations of the Native PostgreSQL Connector.
The "Automatically create the data files if they do not exist" option (in the "Files" tab of the project description) is taken into account by the Native PostgreSQL Connector.