public inbox for [email protected]  

help / color / mirror / Atom feed

From: Ron Johnson <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Way to retrieve UserName/Password
Date: Sat, 22 Nov 2025 22:35:00 -0500
Message-ID: <CANzqJaCzviQo2twKi6rQszo6xe_9s+K3Q0MfVFudW-FOkzog0A@mail.gmail.com> (raw)
In-Reply-To: <CA+FnnTxAbVGgKkWGwowXqfK=1Gkz1=RJdJMG-Pvy168=iaK-aw@mail.gmail.com>
References: <CA+FnnTxAbVGgKkWGwowXqfK=1Gkz1=RJdJMG-Pvy168=iaK-aw@mail.gmail.com>

On Sat, Nov 22, 2025 at 10:22 PM Igor Korot <[email protected]> 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!

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Way to retrieve UserName/Password
  In-Reply-To: <CANzqJaCzviQo2twKi6rQszo6xe_9s+K3Q0MfVFudW-FOkzog0A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox