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

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
>