Re: Need information on bind type for certain data types in PostgreSQL

From: Dave Cramer <davecramer(at)postgres(dot)rocks>
To: Abhishek Kumar <abhishek(dot)aak0(at)gmail(dot)com>
Cc: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Re: Need information on bind type for certain data types in PostgreSQL
Date: 2024-08-23 10:56:12
Message-ID: CADK3HHLfA7mrNhiC96=VExUV3Ka7dEpCLCHjJc4bQy8PbGEfxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi Abhishek,

I think the first three bind to string

Looks like macaddr binds to string as well
case PG_TYPE_MACADDR:
return ansi_to_wtype(conn, SQL_VARCHAR);

Dave Cramer
www.postgres.rocks

On Thu, 22 Aug 2024 at 09:22, Abhishek Kumar <abhishek(dot)aak0(at)gmail(dot)com>
wrote:

> Hi,
>
> I am using the psqlodbc driver with a C++ application. I need to know the
> bind type to use for columns having following data type.
> 1. json
> 2. jsonb
> 3. xml
> 4. macaddr.
>
> Also, do we have a comprehensive list of all the data types and the
> suggested bind types by PostgreSQL? Please help me answer the above
> questions.
>
> Regards,
> Abhishek Kumar
>

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Abhishek Kumar 2024-08-23 12:58:23 Getting error : invalid string conversion occured.
Previous Message Abhishek Kumar 2024-08-22 13:21:55 Need information on bind type for certain data types in PostgreSQL