Re: Way to retrieve UserName/Password

On Sat, Nov 22, 2025 at 10:22 PM Igor Korot <ikorot01(at)gmail(dot)com> wrote:

> 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.
>

Grep the ini file, and add it to your local program's config file?

I sympathize with you about password duplication, though. My .pgpass files
are chock full of duplicate passwords (primary server and multiple
replication servers, plus server-name and server-name.example.com.

Regular expression parsing and case-insensitivity would make users
(including DBAs) lives a *lot* easier.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!