Obsoleted: This project is not maintained now, please refer to the new pgrx project.

Write PostgreSQL extension functions (as stored procedures) using Rust.

Use the Fastest, Efficient, Safe, Enjoyable language, to write In-Database programs, for the World's Most Advanced Open Source Relational Database!

#[macro_use]
extern crate pgxr;
use pgxr::bindings::*;
PG_MODULE_MAGIC!();
PG_FUNCTION_INFO_V1!(pg_finfo_pgxr_example_one);
#[no_mangle]
pub extern "C" fn pgxr_example_one(_fcinfo: FunctionCallInfo) -> Datum
{
 PG_RETURN_I32(1)
}

git clone https://github.com/clia/pgxr.git
cd pgxr/examples/pgxr_example_one
cargo build --release

Then run pg_config

Find PKGLIBDIR, such as /usr/lib/postgresql/11/lib

sudo cp target/release/libpgxr_example_one.so /usr/lib/postgresql/11/lib

sudo su - postgres
psql

CREATE FUNCTION pgxr_example_one() RETURNS integer
 AS 'libpgxr_example_one.so', 'pgxr_example_one'
 LANGUAGE C STRICT;

select pgxr_example_one();

The included bindings.rs is for latest PostgreSQL version, current 11, on the Linux X86-64 arch. You can bindgen your platform's bindings.rs, using:

bindgen wrapper.h -o src/bindings.rs -- -I /usr/include/postgresql/11/server

This repo is for latest PostgreSQL version, current 11, on the Linux platform on X86-64 arch.

There are individual repos for each platform, listed below:

• pgxr_lin_x64_10 - PostgreSQL 10 on Linux on X86-64
• pgxr_lin_x64_11 - PostgreSQL 11 on Linux on X86-64
• pgxr_lin_x64_12 - PostgreSQL 12 on Linux on X86-64
• pgxr_lin_x64_93 - PostgreSQL 9.3 on Linux on X86-64
• pgxr_lin_x64_94 - PostgreSQL 9.4 on Linux on X86-64
• pgxr_lin_x64_95 - PostgreSQL 9.5 on Linux on X86-64
• pgxr_lin_x64_96 - PostgreSQL 9.6 on Linux on X86-64
• pgxr_mac_x64_10 - PostgreSQL 10 on macOS on X86-64
• pgxr_mac_x64_11 - PostgreSQL 11 on macOS on X86-64

You can simply change the crate path in your Cargo.toml (No change the crate name pgxr) to develop for your target platform.

That is it.

Have fun!