sys pq-sys

Auto-generated rust bindings for libpq

22 releases

Uses old Rust 2015

0.5.0 Jan 19, 2024
0.4.8 Apr 18, 2023
0.4.7 Jul 18, 2022
0.4.6 Jul 15, 2018
0.2.0 Nov 21, 2015

#1 in #autogenerated

Download history 50247/week @ 2023-11-02 47566/week @ 2023-11-09 50131/week @ 2023-11-16 45918/week @ 2023-11-23 48410/week @ 2023-11-30 45752/week @ 2023-12-07 43852/week @ 2023-12-14 31187/week @ 2023-12-21 31547/week @ 2023-12-28 50587/week @ 2024-01-04 53207/week @ 2024-01-11 65661/week @ 2024-01-18 59710/week @ 2024-01-25 62729/week @ 2024-02-01 57141/week @ 2024-02-08 48976/week @ 2024-02-15

239,247 downloads per month
Used in 212 crates (via diesel)


16K SLoC

C 9K SLoC // 0.3% comments Rust 7K SLoC // 0.0% comments Perl 331 SLoC // 0.2% 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

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, 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


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.