Thread: Need information on bind type for certain data types in PostgreSQL
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. json2. jsonb3. xml4. 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