Driver=PostgreSQL Unicode;Server=myserver;Database=mydb;SSPI=1;Trusted_Connection=yes;

$connString = "Driver=PostgreSQL Unicode;Server=localhost;Database=testdb;Uid=postgres;Pwd=secret;" $conn = New-Object System.Data.Odbc.OdbcConnection($connString) $conn.Open() $cmd = $conn.CreateCommand() $cmd.CommandText = "SELECT datname FROM pg_database" $reader = $cmd.ExecuteReader()

sudo yum install postgresql-odbc # or with dnf sudo dnf install postgresql-odbc After installation, verify the driver configuration in /etc/odbcinst.ini :

UseDeclareFetch=1 Fetch=1000 CacheSize=500

+---------------------------------------+ | Connected! | | sql-statement | | help [tablename] | | quit | +---------------------------------------+ SQL> | Driver Version | PostgreSQL Versions | ODBC Standard | |----------------|---------------------|---------------| | 9.x | 8.4 - 11 | 3.5 | | 10.x | 9.x - 13 | 3.5 | | 11.x | 10 - 14 | 3.5 | | 12.x | 11 - 15+ | 3.5 | | 13.x | 12 - 16+ | 3.5 |

Click to verify connectivity, then Save . Manual DSN Configuration (odbc.ini) On Linux/macOS, edit ~/.odbc.ini (user DSN) or /etc/odbc.ini (system DSN):

UseServerSidePrepare=1 CommLog=0

关于我们

about us

专业成就品牌，敬业铸造精品，服务赢得信赖

1999

始于口碑

20+

连接线生产经验

500+

行业成功案例

致力于成为高端线缆制品消费引导者

作为国内首批涉足电脑周边产品的专业制造商，自1999年以来，Z-TEK坚持以自主研发、生产、外贸、OEM/ODM于一体的完整性及规范化的运营模式，产品具备独特的外观、新颖的结构、严谨的工艺、优良的品质、健全的测试认证，树立高新电子产品的前端地位。

未来， Z-TEK 将持续保持产品的竟争力和先进性，矢志成为高端线缆制品消费引导者。对产品积极创新，精益求精，对用户竭诚尽责，坚持不懈。

“专业成就品牌，敬业铸造精品，服务赢得信赖。”Z-TEK时刻恪守自己的承诺，携手广大客户共创美好未来。

了解更多

Odbc Postgres Driver -

Driver=PostgreSQL Unicode;Server=myserver;Database=mydb;SSPI=1;Trusted_Connection=yes;

sudo yum install postgresql-odbc # or with dnf sudo dnf install postgresql-odbc After installation, verify the driver configuration in /etc/odbcinst.ini : $connString = "Driver=PostgreSQL Unicode

UseDeclareFetch=1 Fetch=1000 CacheSize=500 odbc postgres driver