ODBC连接PostgreSql

2024-04-15

安装驱动：

1 2	yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm yum install postgresql15-odbc

TODO 离线包

配置 /etc/odbcinst.ini

[PostgreSQL]
Description=ODBC for PostgreSQL
Driver=/usr/pgsql-15/lib/psqlodbcw.so
Debug=0
CommLog=1
UsageCount=1

测试连接：

isql -v -k 'DRIVER={PostgreSQL};SERVER=192.168.2.181;PORT=15432;UID=abcdu;PWD=123456;DATABASE=test;'
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+

jsonContent: meta: false pages: false posts: title: true date: true path: true text: false raw: false content: false slug: false updated: false comments: false link: false permalink: false excerpt: false categories: false tags: true