G2

CS

Chandru S.

Senior Software Engineer

Enterprise (> 1000 emp.)

2/19/2025

"Quick connect with Postgresql and both source and binary format is very useful"

5/5

What do you like best about ODBC driver for PostgreSQL?

I am a Windows user, thus we can find the ODBC admin panel to manage the data source. Previously, ODBC Administrator was present in the Control Panel. Now we can find the Administrative Tools folder.I can quickly add new data sources, edit old ones, and delete them.It's incredibly helpful to me as a DBA in PostgreSQL Review collected by and hosted on G2.com.

What do you dislike about ODBC driver for PostgreSQL?

Sometimes I can't index text fields because I get "Invalid field definition 'field'" in the index or relationship definition.

We can alter the mapping of Text fields to SQL_VARCHAR by unchecking the Advanced driver option "Text as LongVarchar" in the Data Type Options. However, it will be limited to the maximum size of a varchar. So it's frustrating sometimes. Review collected by and hosted on G2.com.

What problems is ODBC driver for PostgreSQL solving and how is that benefiting you?

post gre sql supporting most of data types so I can't worry about database implementation and optimization and also it supports large object.In post gresql large objects are mapped in LONGVARBINARY so I can store OLE objects in Microsoft Access.this is very helpful to store large objects Review collected by and hosted on G2.com.