more quick actions
minimize quick actions
Topic starter
PostgreSQL is "the world's most advanced open-source relational database". It's made by PostgreSQL Global Development Group.
Unfortunately, PostgreSQL like some open source projects such as Maria DB does not offer a ready to use ADO.NET provider.
Once the binaries are obtained it is possible to install a third party provider with the tool : "ProviderInstaller.exe".
To be detected by PcVue, each ADO.NET provider must be installed in the Global Assembly Cache (GAC) of the .NET framework and referenced in the machine.config file. The tool "ProviderInstaller.exe" is there to facilitate this task.
-- How to install PostgreSQL ADO.NET Provider --
Optional: Build Binaries for .NET from
EDB Connectors => PostgreSQL Precompiled Binaries for .NET https://www.enterprisedb.com/software-downloads-postgres ,
select following version of binaries: Windows x86-32
and merge assemblies (.dll) from netstandard2.0 folder with a tool like ILMerge.
1. Download Attachment "ProviderInstaller - PostgreSQL.zip"
2. Extract "ProviderInstaller - PostgreSQL.zip" to "ProviderInstaller - PostgreSQL"
3. Open CMD prompt as Administrator
4. Change directory to be in "ProviderInstaller - PostgreSQL" directory
Ex:
cd "C:UsersardeDownloadsProviderInstaller - PostgreSQLProviderInstaller - PostgreSQL"
5. Run following command:
ProviderInstaller.exe /install
The installation is complete !!
The provider is now visible in PcVue SQL Connection (Data source : Other providers).
-- Connection string --
. Connection string without password:
host=127.0.0.1;username=postgres;database=MyDatabase;port=5432
. Connection string with password:
host=127.0.0.1;username=postgres;password=MySecret;database=MyDatabase;port=5432
-- Sql queries --
. Create a database
CREATE DATABASE MyDatabase
. Create a table
CREATE TABLE MyTable (col1 INT)
. Insert a value
INSERT INTO MyTable (col1) VALUES (1)
. Display table content
SELECT * FROM MyTable
Found more samples here
Posted : 31/08/2023 6:28 pm