SUSE 11 SP3上通过ODBC连接OushuDB

# cat /etc/unixODBC/odbcinst.ini
[PostgreSQLODBC]
Description = PostgreSQL driver for linux
Driver = /usr/lib64/unixODBC/libodbcpsql.so
Setup = /usr/lib64/unixODBC/libodbcpsqlS.so

# cat /etc/unixODBC/odbc.ini
[OushuDB]
Driver = PostgreSQLODBC
Description = HAWQ DSN
Servername = 10.0.193.85
Database = postgres
Username = gpadmin
Password = gparray
Port = 5432
ReadOnly = No

在/etc/unixODBC/odbc.ini 中添加以下两个参数：

Fetch = 10000
UseDeclareFetch = 1