Postgres Pro
Downloads
Home   >   mailing lists

Re: Need information on bind type for certain data types in PostgreSQL - Mailing list pgsql-odbc

From Dave Cramer
Subject Re: Need information on bind type for certain data types in PostgreSQL
Date
Msg-id CADK3HHLfA7mrNhiC96=VExUV3Ka7dEpCLCHjJc4bQy8PbGEfxw@mail.gmail.com
Whole thread Raw
In response to Need information on bind type for certain data types in PostgreSQL  (Abhishek Kumar <abhishek.aak0@gmail.com>)
List pgsql-odbc
Tree view
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.aak0@gmail.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

pgsql-odbc by date:

Previous
From: Abhishek Kumar
Date:
Subject: Need information on bind type for certain data types in PostgreSQL
Next
From: Abhishek Kumar
Date:
Subject: Getting error : invalid string conversion occured.