MIME-Version: 1.0
From: Igor Korot <ikorot01@gmail.com>
Date: Sat, 22 Nov 2025 21:21:46 -0600
Message-ID: <CA+FnnTxAbVGgKkWGwowXqfK=1Gkz1=RJdJMG-Pvy168=iaK-aw@mail.gmail.com>
Subject: Way to retrieve UserName/Password
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTxAbVGgKkWGwowXqfK%3D1Gkz1%3DRJdJMG-Pvy168%3DiaK-aw%40mail.gmail.com>
Precedence: bulk

Hi, ALL,
I successfully built the server and I previously had the odbc driver installed.

I can successfully connect from psql from the Terminal, and from isql
unixODBC utility.

However, what I wonder is - is there a simple way to retrieve UsrerName
and Password from odbc.ini file?

Below is my current configuration to connect.

WHat I'd like to do in my software is to get those parameters and use
them in the "Connect To DB" dialog.

The easiest would probably be to save it in my local program configuration file,
but in this case the information will be duplicated and I'd like to avoid it.

Thank you.


[code]
igor@WaylandGnome ~/dbhandler/Debug $ cat /etc/unixODBC/odbcinst.ini
[ODBC]
Trace=Yes
TraceFile=/var/log/unixodbc.log

[postgres]
Description=Postgres ODBC Driver
Driver=/usr/lib64/psqlodbcw.so
FileUsage=1

igor@WaylandGnome ~/dbhandler/Debug $ cat /etc/unixODBC/odbc.ini
[postgres]
Driver=Postgres
Description=Postgres ODBC Driver
UserId=postgres
Password=wasqra
Servername=localhost
Database=draft
Port=5432

[ODBC]
Trace = Yes
TraceFile = /home/igor/odbc.log

[ODBC Data Sources]
postgres=PostgreSQL Driver testing

igor@WaylandGnome ~/dbhandler/Debug $
[/code]