pg-ethopic

A PostgreSQL extension for formatting ethiopic dates and numbers.

Usage

Run a PostgreSQL 17 database that has pg-ethopic already installed.

docker run --network=host frectonz/pg-ethopic

pg-ethopic is also distributed with other PostgreSQL versions.

PostgreSQL 13

docker run --network=host frectonz/pg-ethopic:pg13

PostgreSQL 14

docker run --network=host frectonz/pg-ethopic:pg14

PostgreSQL 15

docker run --network=host frectonz/pg-ethopic:pg15

PostgreSQL 16

docker run --network=host frectonz/pg-ethopic:pg16

PostgreSQL 17

docker run --network=host frectonz/pg-ethopic:pg17

Connect to the PostgreSQL database using psql.

psql postgresql://postgres@localhost:5432/

Here's some demo usage.

-- Load PG extension
CREATE EXTENSION pg_ethopic;

-- Format the current date as an ethiopic date.
SELECT ethopic_date(CURRENT_DATE);

-- Format the current date as an ethiopic date with a custom format template.
SELECT ethopic_date(CURRENT_DATE, '{year}/{month}/{day}');

-- Format  a given number as an ethopic number.
SELECT ethopic_number(420);