PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Overview
  • Required configuration
  • Conditions for using a Native Progress Connector
  • Specific file supplied with Native PostgreSQL Connector
  • Use
  • Using Native PostgreSQL Connector in your WINDEV applications and WEBDEV sites
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Overview
WINDEV and WEBDEV 27 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.
Caution: This version of Native PostgreSQL Connector operates with WINDEV and WEBDEV version 27.
Remark: The Native PostgreSQL Connector is an optional and free module that can be downloaded from the PC SOFT site.
Required configuration

Conditions for using a Native Progress Connector

We recommend that you use a recent PostgreSQL client layer, whose version is identical to the version of your server if possible.
To do so, you must:
  • Copy the DLLs of PostgreSQL client layer into the setup directory of WINDEV or WEBDEV on the development computer.
  • Copy the DLLs of PostgreSQL client layer into the executable directory or into the Windows directory on the development computer.
  • Install the DLLs of Visual runtime (package that can be downloaded from Microsoft site).
    Remark: The version of visual runtime depends of PostgreSQL client layer.
In 32-bit, if these DLLs are not found, the Native PostgreSQL Connector will be using a standard client layer corresponding to the version 7.4.23 of PostgreSQL. It contains all features required by the Native Access and it is compatible with the most recent servers (8.3.6).
Linux The PostgreSQL client layer should be installed with the Linux distribution package manager. Dependencies will also be installed.
Example (Debian):
apt-get install libpq5
Remark: To use the SSL connections, you must install a PostgreSQL client layer version 9.1 or later.

Specific file supplied with Native PostgreSQL Connector

To use Native PostgreSQL Connector:
  • in 32-bit, only the wdxxxpostgresql.DLL DLL is required. This file is provided with the Native PostgreSQL Connector for WINDEV and WEBDEV.
  • Versions 20 and later
    in 64-bit, only the wdxxxpostgresql64.DLL DLL is required. This file is provided with the Native PostgreSQL Connector for WINDEV and WEBDEV.
    New in version 20
    in 64-bit, only the wdxxxpostgresql64.DLL DLL is required. This file is provided with the Native PostgreSQL Connector for WINDEV and WEBDEV.
    in 64-bit, only the wdxxxpostgresql64.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 sites

To use PostgreSQL in native mode, you must program in the WINDEV application or in the WEBDEV site:
Remarks:
  • Don't forget to read the limitations of the Native PostgreSQL Connector.
  • Versions 23 and later
    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.
    New in version 23
    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.
    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.
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment