1. 下载库文件和示例代码
国外下载: http://lefa.idealand.xyz/Files/Software/postgres.zip
国内下载:https://bzc.idealand.xyz:8600/dl/postgres.zip/dl
解压缩以后放到 $(SolutionDir)libs\ 文件夹里面
2. VS2022设置库
项目属性
C/C++ - Additional Include Directories : $(SolutionDir)libs\postgres\windows\x64\include\
Linker - Additional Library Directories: $(SolutionDir)libs\postgres\windows\x64\lib\;
Linker - input - Additional Dependencies: libpq.lib;
3. 拷贝dll
将postgres\windows\x64\bin\ 里面的6个dll文件拷贝到 $(SolutionDir)x64\Debug\
4. 编译运行测试程序
postgres\testlibpq.c
其中的数据库连接字符串可参考:
const char* conn_string="user=postgres password=password_of_postgres_user host=myhost port=5432 dbname=database_name connect_timeout=5";
参考资料
PostgreSQL二进制包
https://www.enterprisedb.com/download-postgresql-binaries
PostgreSQL源代码
https://git.postgresql.org/gitweb/?p=postgresql.git;a=tree
C语言API
https://www.postgresql.org/docs/current/libpq.html
https://spapas.github.io/2022/09/20/postgresql-windows-dev/