Connecting to PostgreSQL
The SaveToDB add-in allows connecting to PostgreSQL tables, views, and functions.
The SaveToDB add-in supports the following data providers:
- PostgreSQL ODBC Driver.
- Npgsql .NET PostgreSQL Data Provider.
The add-in ships the .NET data provider. So, you can use it from the box.
You can download PostgreSQL ODBC drivers at https://www.postgresql.org/ftp/odbc/versions/msi/.
Microsoft Excel supports PostgreSQL ODBC drivers but does not support connecting to functions that return ref cursors.
Microsoft Excel does not support .NET data providers. So, you can reload data connected with the .NET data providers using the add-in only.
Here is a sample of the Database Connection Wizard page where you can select the data provider:
Connecting to PostgreSQL Databases
Use the following server name format for PostgreSQL:
<Server name or IP-address>[;port=<Port>]
Here is a sample of the connection to the samples database on the localhost:
Below is a sample of the connection to the samples database on localhost port 5432: