MIME-Version: 1.0
References: <CA+FnnTxAbVGgKkWGwowXqfK=1Gkz1=RJdJMG-Pvy168=iaK-aw@mail.gmail.com>
In-Reply-To: <CA+FnnTxAbVGgKkWGwowXqfK=1Gkz1=RJdJMG-Pvy168=iaK-aw@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sat, 22 Nov 2025 22:35:00 -0500
Message-ID: <CANzqJaCzviQo2twKi6rQszo6xe_9s+K3Q0MfVFudW-FOkzog0A@mail.gmail.com>
Subject: Re: Way to retrieve UserName/Password
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000df08b606443abbac"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCzviQo2twKi6rQszo6xe_9s%2BK3Q0MfVFudW-FOkzog0A%40mail.gmail.com>
Precedence: bulk

--000000000000df08b606443abbac
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sat, Nov 22, 2025 at 10:22=E2=80=AFPM Igor Korot <ikorot01@gmail.com> wr=
ote:

> 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 configuratio=
n
> 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.

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

--000000000000df08b606443abbac
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Sat, Nov 22, 2025 at 10:22=E2=80=AFPM =
Igor Korot &lt;<a href=3D"mailto:ikorot01@gmail.com">ikorot01@gmail.com</a>=
&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquo=
te class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px =
solid rgb(204,204,204);padding-left:1ex">Hi, ALL,<br>
I successfully built the server and I previously had the odbc driver instal=
led.<br>
<br>
I can successfully connect from psql from the Terminal, and from isql<br>
unixODBC utility.<br>
<br>
However, what I wonder is - is there a simple way to retrieve UsrerName<br>
and Password from odbc.ini file?<br>
<br>
Below is my current configuration to connect.<br>
<br>
WHat I&#39;d like to do in my software is to get those parameters and use<b=
r>
them in the &quot;Connect To DB&quot; dialog.<br>
<br>
The easiest would probably be to save it in my local program configuration =
file,<br>
but in this case the information will be duplicated and I&#39;d like to avo=
id it.<br></blockquote><div><br></div><div>Grep the ini file, and add it to=
 your local program&#39;s config file?</div><div><br></div><div>I sympathiz=
e with you about password duplication, though.=C2=A0 My .pgpass files are c=
hock full of duplicate passwords (primary server and multiple replication s=
ervers, plus server-name and <a href=3D"http://server-name.example.com">ser=
ver-name.example.com</a>.</div><div><br></div><div>Regular expression parsi=
ng and case-insensitivity would make users (including DBAs) lives a <b>lot<=
/b>=C2=A0easier.</div><div>=C2=A0</div></div><span class=3D"gmail_signature=
_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=
=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me=
, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></=
div></div></div></div>

--000000000000df08b606443abbac--