Installation

DuckDB

Quick Install

Install from the community extension repository:

INSTALL monetary FROM community;
LOAD monetary;

Verify Installation

-- Check extension is loaded
SELECT '100 EUR'::monetary;
-- Returns: 100.00 EUR

-- Check currency lookup works
SELECT currency_for_country('US');
-- Returns: USD

Persistent Loading

Add to your ~/.duckdbrc to load automatically:

INSTALL monetary FROM community;
LOAD monetary;

Or in Python:

import duckdb

conn = duckdb.connect()
conn.execute("INSTALL monetary FROM community")
conn.execute("LOAD monetary")

# Now use monetary types
result = conn.execute("SELECT '99.99 USD'::monetary").fetchone()
print(result[0])  # 99.99 USD

Dependencies

The extension auto-installs httpfs for exchange rate functions. No manual setup needed.

---

PostgreSQL

Build from Source

git clone https://github.com/fyffee/monetary.git
cd monetary/pg_monetary/cpp
make
sudo make install

Enable Extension

CREATE EXTENSION pg_monetary;

Verify Installation

-- Check monetary type
SELECT '100 EUR'::monetary;
-- Returns: 100.00 EUR

-- Check currency functions
SELECT currency_for_country('DE');
-- Returns: EUR

-- Check arithmetic
SELECT '50 USD'::monetary + '25 USD'::monetary;
-- Returns: 75.00 USD

pgxman (Alternative)

If you use pgxman:

pgxman install pg_monetary

---

Version Compatibility

Database	Minimum Version
DuckDB	1.4.3+
PostgreSQL	14+

---

Development Setup

For contributors or those who want to build from source:

git clone https://github.com/fyffee/monetary.git
cd monetary

Using devenv (Recommended)

# Install devenv if you don't have it
curl -sfL https://devenv.sh/install.sh | bash

# Enter development environment
devenv shell

# Build all extensions
build-all

# Run tests
test-all

Manual Build (DuckDB)

cd duckdb_monetary
make release GEN=ninja

# Run tests
make test GEN=ninja

Manual Build (PostgreSQL)

cd pg_monetary/cpp
make
sudo make install

# Test
psql -c "CREATE EXTENSION pg_monetary;"
psql -c "SELECT '100 EUR'::monetary;"