6 releases

new 0.1.6 Apr 12, 2024
0.1.5 Apr 10, 2024
0.1.2 Mar 8, 2024
0.1.1 Feb 9, 2024
0.1.0 Jan 19, 2024

#2264 in Database interfaces

Download history 8/week @ 2024-01-19 5/week @ 2024-02-09 234/week @ 2024-02-16 589/week @ 2024-02-23 286/week @ 2024-03-01 256/week @ 2024-03-08 80/week @ 2024-03-15 112/week @ 2024-03-22 422/week @ 2024-03-29 887/week @ 2024-04-05

1,509 downloads per month
Used in pq-sys


37K SLoC

C 36K SLoC // 0.3% comments Perl 1.5K SLoC // 0.2% comments Rust 263 SLoC // 0.0% comments


Autogenerated Rust bindings for libpq


This repository contains direct, one-to-one mappings to the C functions provided in libpq-fe.h and postgres_ext.h. This library expects that libpq be installed on the system.

The build script of crate will attempt to find the lib path of libpq using the following methods:

  • First it will look for an environment variable in the format of PQ_LIB_DIR_{TARGET} where {TARGET} gets replaced by the Target environment variable set for cross-compilation
  • Second, if the environment variable PQ_LIB_DIR is set, it will use its value
  • If the environment variable isn't set, it tries to use pkg-config to locate it. All the config options, such as PKG_CONFIG_ALLOW_CROSS, PKG_CONFIG_ALL_STATIC etc., of the crate pkg-config apply.
  • Then, for MSVC ABI builds the build script will attempt use the library from a vcpkg installation if there is one available. You may need to set VCPKG_ROOT (or run vcpkg integrate install), set VCPKGRS_DYNAMIC=1, and run vcpkg install libpq:x64-windows. See the documentation for the vcpkg crate for more.
  • If it still can't locate the library, it will invoke the Postgres command pg_config --libdir

The build script instructs Cargo to link the library statically if the environmental variable PQ_LIB_STATIC is set. This can be useful, if targeting for a musl target. If pkg-config is being used, it's configuration options will apply.


I'm seeing dyld: Symbol not found __cg_jpeg_resync_to_restart on macOS

This is caused when the output of pg_config --libdir is a directory that also contains libjpeg.dylib which differs from the system libjpeg. This is usually caused by install postgres via homebrew, or using postgresapp.com.

If you've installed via homebrew, you should not see this issue unless you've provided features = ["pkg-config"]. You can work around the issue by exporting PQ_LIB_DIR="$(brew --prefix postgres)/lib".

If you've installed postgresql using postgresapp.com, you will not be able to run your binaries using cargo run or cargo test. You can compile the binary manually via cargo build and then run /target/debug/yourapp. You can also manually create a directory that contains only a symlink to libpq.dylib and nothing else, then export PQ_LIB_DIR to that directory. It is recommended that you do not use postgresapp.com.


Licensed under either of

at your option.


Unless you explicitly state otherwise, any contribution intentionally submitted for inclusion in the work by you, as defined in the Apache-2.0 license, shall be dual licensed as above, without any additional terms or conditions.


~87K SLoC