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

Need information on bind type for certain data types in PostgreSQL

From
Abhishek Kumar
Date:
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
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