Re: Distribution package for OSX - Mailing list pgsql-odbc

Adrian,

On Sat, Dec 3, 2016 at 9:25 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
> On 12/02/2016 07:38 PM, Igor Korot wrote:
>>
>> Hi, Adrian,
>>
>> On Fri, Dec 2, 2016 at 1:29 AM, Adrian Klaver <adrian.klaver@aklaver.com>
>> wrote:
>>>
>>> On 12/01/2016 08:47 PM, Igor Korot wrote:
>>>>
>>>>
>>>> Hi, Tom,
>>>>
>>>> On Thu, Dec 1, 2016 at 10:48 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>>>>
>>>>>
>>>>> Igor Korot <ikorot01@gmail.com> writes:
>>>>>>
>>>>>>
>>>>>> This is what I get trying to compile latest source:
>>>>>
>>>>>
>>>>>
>>>>>>> checking for PQsetSingleRowMode in -lpq... no
>>>>>>> configure: error: libpq library version >= 9.2 is required
>>>>>
>>>>>
>>>>>
>>>>> Apple does ship a copy of libpq in /usr/lib, but it's generally a bit
>>>>> back-rev, and you're working in a macOS release that's itself several
>>>>> years out of date.  You'll need to install a newer libpq to satisfy
>>>>> this
>>>>> ODBC version, evidently.
>>>>
>>>>
>>>>
>>>> Is there a way to see what version of PostgreSQL is installed on
>>>> the system?
>>>> Because then it would be easy to find out what version of ODBC
>>>> driver I should have to connect.
>>>> Or maybe I already have the driver, since I have iODBC installed?
>>>
>>>
>>>
>>> A question I should have asked earlier, is it a requirement that ODBC be
>>> used for the connection?
>>>
>>> In other words is this a third party app needing ODBC or something you
>>> wrote
>>> that you want to connect via ODBC?
>>
>>
>> This is a software I'm writing and for testing purposes I need to use it.
>> It is cross-platform cross-database one.
>>
>> One of the use-cases is to connect to the PostgreSQL thru the ODBC.
>>
>> BTW, is there another way (a "native" way to talk to PostgreSQL server?
>
>
> Using libpq:
>
> https://www.postgresql.org/docs/9.5/static/libpq.html
>
> There is also JDBC:
>
> https://jdbc.postgresql.org/
>
> Then there are all the other language bindings eg Python, PERL, etc. It
> really depends on what you are calling native.

Using libpg, as it uses PostgreSQL calls, and I presume, is written in C/C++.
Versus ODBC/JDBC which ingtroducec another layer in between client app and
DB server.

Thank you.

>
>
>>
>> Thank you.
>>
>>>
>>>
>>>>
>>>> Just checked - driver is not there.
>>>>
>>>> Thank you.
>>>>
>>>>>
>>>>> There isn't any separate distribution of libpq alone; you need to
>>>>> build and install all of Postgres into, say, /usr/local.  That's
>>>>> not hard, but if you don't enjoy rolling it all yourself, you might
>>>>> want to consider installing from MacPorts or Homebrew.
>>>>>
>>>>>                         regards, tom lane
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Adrian Klaver
>>> adrian.klaver@aklaver.com
>>
>>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com