convert

conversion functions for spatial, routing and other specialized uses

Overview

Package	Version	Category	License	Language
`pg_convert`	`0.1.0`	FUNC	MIT	Rust

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
4850	`convert`	No	Yes	No	Yes	No	No	`convert`

Related	`postgis` `pg_eviltransform` `earthdistance` `h3` `ogr_fdw` `nominatim_fdw`

Version

Type	Repo	Version	PG Ver	Package	Deps
EXT	PIGSTY	`0.1.0`	1817161514	`pg_convert`	-
RPM	PIGSTY	`0.1.0`	1817161514	`pg_convert_$v`	-
DEB	PIGSTY	`0.1.0`	1817161514	`postgresql-$v-convert`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 0.1.0 el8.x86_64.pg18 : pg_convert_18 pg_convert_18-0.1.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.0 · 844.0KiB	PIGSTY 0.1.0 el8.x86_64.pg17 : pg_convert_17 pg_convert_17-0.1.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.0 · 841.2KiB	PIGSTY 0.1.0 el8.x86_64.pg16 : pg_convert_16 pg_convert_16-0.1.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.0 · 840.4KiB	PIGSTY 0.1.0 el8.x86_64.pg15 : pg_convert_15 pg_convert_15-0.1.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.0 · 830.8KiB	PIGSTY 0.1.0 el8.x86_64.pg14 : pg_convert_14 pg_convert_14-0.1.0-3PIGSTY.el8.x86_64.rpm PIGSTY · 0.1.0 · 826.8KiB
el8.aarch64	PIGSTY 0.1.0 el8.aarch64.pg18 : pg_convert_18 pg_convert_18-0.1.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.0 · 760.5KiB	PIGSTY 0.1.0 el8.aarch64.pg17 : pg_convert_17 pg_convert_17-0.1.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.0 · 757.2KiB	PIGSTY 0.1.0 el8.aarch64.pg16 : pg_convert_16 pg_convert_16-0.1.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.0 · 755.6KiB	PIGSTY 0.1.0 el8.aarch64.pg15 : pg_convert_15 pg_convert_15-0.1.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.0 · 746.6KiB	PIGSTY 0.1.0 el8.aarch64.pg14 : pg_convert_14 pg_convert_14-0.1.0-3PIGSTY.el8.aarch64.rpm PIGSTY · 0.1.0 · 744.3KiB
el9.x86_64	PIGSTY 0.1.0 el9.x86_64.pg18 : pg_convert_18 pg_convert_18-0.1.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.0 · 852.6KiB	PIGSTY 0.1.0 el9.x86_64.pg17 : pg_convert_17 pg_convert_17-0.1.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.0 · 849.3KiB	PIGSTY 0.1.0 el9.x86_64.pg16 : pg_convert_16 pg_convert_16-0.1.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.0 · 849.0KiB	PIGSTY 0.1.0 el9.x86_64.pg15 : pg_convert_15 pg_convert_15-0.1.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.0 · 840.6KiB	PIGSTY 0.1.0 el9.x86_64.pg14 : pg_convert_14 pg_convert_14-0.1.0-3PIGSTY.el9.x86_64.rpm PIGSTY · 0.1.0 · 836.4KiB
el9.aarch64	PIGSTY 0.1.0 el9.aarch64.pg18 : pg_convert_18 pg_convert_18-0.1.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.0 · 806.8KiB	PIGSTY 0.1.0 el9.aarch64.pg17 : pg_convert_17 pg_convert_17-0.1.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.0 · 803.7KiB	PIGSTY 0.1.0 el9.aarch64.pg16 : pg_convert_16 pg_convert_16-0.1.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.0 · 801.6KiB	PIGSTY 0.1.0 el9.aarch64.pg15 : pg_convert_15 pg_convert_15-0.1.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.0 · 792.0KiB	PIGSTY 0.1.0 el9.aarch64.pg14 : pg_convert_14 pg_convert_14-0.1.0-3PIGSTY.el9.aarch64.rpm PIGSTY · 0.1.0 · 788.4KiB
el10.x86_64	PIGSTY 0.1.0 el10.x86_64.pg18 : pg_convert_18 pg_convert_18-0.1.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.0 · 852.0KiB	PIGSTY 0.1.0 el10.x86_64.pg17 : pg_convert_17 pg_convert_17-0.1.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.0 · 849.8KiB	PIGSTY 0.1.0 el10.x86_64.pg16 : pg_convert_16 pg_convert_16-0.1.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.0 · 849.3KiB	PIGSTY 0.1.0 el10.x86_64.pg15 : pg_convert_15 pg_convert_15-0.1.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.0 · 840.0KiB	PIGSTY 0.1.0 el10.x86_64.pg14 : pg_convert_14 pg_convert_14-0.1.0-3PIGSTY.el10.x86_64.rpm PIGSTY · 0.1.0 · 835.7KiB
el10.aarch64	PIGSTY 0.1.0 el10.aarch64.pg18 : pg_convert_18 pg_convert_18-0.1.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.0 · 784.9KiB	PIGSTY 0.1.0 el10.aarch64.pg17 : pg_convert_17 pg_convert_17-0.1.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.0 · 785.1KiB	PIGSTY 0.1.0 el10.aarch64.pg16 : pg_convert_16 pg_convert_16-0.1.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.0 · 785.7KiB	PIGSTY 0.1.0 el10.aarch64.pg15 : pg_convert_15 pg_convert_15-0.1.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.0 · 779.7KiB	PIGSTY 0.1.0 el10.aarch64.pg14 : pg_convert_14 pg_convert_14-0.1.0-3PIGSTY.el10.aarch64.rpm PIGSTY · 0.1.0 · 777.6KiB
d12.x86_64	PIGSTY 0.1.0 d12.x86_64.pg18 : postgresql-18-convert postgresql-18-convert_0.1.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.0 · 673.3KiB	PIGSTY 0.1.0 d12.x86_64.pg17 : postgresql-17-convert postgresql-17-convert_0.1.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.0 · 670.0KiB	PIGSTY 0.1.0 d12.x86_64.pg16 : postgresql-16-convert postgresql-16-convert_0.1.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.0 · 671.9KiB	PIGSTY 0.1.0 d12.x86_64.pg15 : postgresql-15-convert postgresql-15-convert_0.1.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.0 · 663.1KiB	PIGSTY 0.1.0 d12.x86_64.pg14 : postgresql-14-convert postgresql-14-convert_0.1.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 0.1.0 · 661.3KiB
d12.aarch64	PIGSTY 0.1.0 d12.aarch64.pg18 : postgresql-18-convert postgresql-18-convert_0.1.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.0 · 563.3KiB	PIGSTY 0.1.0 d12.aarch64.pg17 : postgresql-17-convert postgresql-17-convert_0.1.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.0 · 561.8KiB	PIGSTY 0.1.0 d12.aarch64.pg16 : postgresql-16-convert postgresql-16-convert_0.1.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.0 · 560.7KiB	PIGSTY 0.1.0 d12.aarch64.pg15 : postgresql-15-convert postgresql-15-convert_0.1.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.0 · 555.8KiB	PIGSTY 0.1.0 d12.aarch64.pg14 : postgresql-14-convert postgresql-14-convert_0.1.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 0.1.0 · 554.6KiB
d13.x86_64	PIGSTY 0.1.0 d13.x86_64.pg18 : postgresql-18-convert postgresql-18-convert_0.1.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.1.0 · 673.1KiB	PIGSTY 0.1.0 d13.x86_64.pg17 : postgresql-17-convert postgresql-17-convert_0.1.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.1.0 · 671.3KiB	PIGSTY 0.1.0 d13.x86_64.pg16 : postgresql-16-convert postgresql-16-convert_0.1.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.1.0 · 672.0KiB	PIGSTY 0.1.0 d13.x86_64.pg15 : postgresql-15-convert postgresql-15-convert_0.1.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.1.0 · 664.4KiB	PIGSTY 0.1.0 d13.x86_64.pg14 : postgresql-14-convert postgresql-14-convert_0.1.0-3PIGSTY~trixie_amd64.deb PIGSTY · 0.1.0 · 661.7KiB
d13.aarch64	PIGSTY 0.1.0 d13.aarch64.pg18 : postgresql-18-convert postgresql-18-convert_0.1.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.1.0 · 563.2KiB	PIGSTY 0.1.0 d13.aarch64.pg17 : postgresql-17-convert postgresql-17-convert_0.1.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.1.0 · 562.4KiB	PIGSTY 0.1.0 d13.aarch64.pg16 : postgresql-16-convert postgresql-16-convert_0.1.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.1.0 · 561.3KiB	PIGSTY 0.1.0 d13.aarch64.pg15 : postgresql-15-convert postgresql-15-convert_0.1.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.1.0 · 556.1KiB	PIGSTY 0.1.0 d13.aarch64.pg14 : postgresql-14-convert postgresql-14-convert_0.1.0-3PIGSTY~trixie_arm64.deb PIGSTY · 0.1.0 · 555.2KiB
u22.x86_64	PIGSTY 0.1.0 u22.x86_64.pg18 : postgresql-18-convert postgresql-18-convert_0.1.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.1.0 · 749.4KiB	PIGSTY 0.1.0 u22.x86_64.pg17 : postgresql-17-convert postgresql-17-convert_0.1.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.1.0 · 748.8KiB	PIGSTY 0.1.0 u22.x86_64.pg16 : postgresql-16-convert postgresql-16-convert_0.1.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.1.0 · 747.1KiB	PIGSTY 0.1.0 u22.x86_64.pg15 : postgresql-15-convert postgresql-15-convert_0.1.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.1.0 · 738.7KiB	PIGSTY 0.1.0 u22.x86_64.pg14 : postgresql-14-convert postgresql-14-convert_0.1.0-3PIGSTY~jammy_amd64.deb PIGSTY · 0.1.0 · 736.2KiB
u22.aarch64	PIGSTY 0.1.0 u22.aarch64.pg18 : postgresql-18-convert postgresql-18-convert_0.1.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.1.0 · 665.2KiB	PIGSTY 0.1.0 u22.aarch64.pg17 : postgresql-17-convert postgresql-17-convert_0.1.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.1.0 · 663.0KiB	PIGSTY 0.1.0 u22.aarch64.pg16 : postgresql-16-convert postgresql-16-convert_0.1.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.1.0 · 663.4KiB	PIGSTY 0.1.0 u22.aarch64.pg15 : postgresql-15-convert postgresql-15-convert_0.1.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.1.0 · 658.3KiB	PIGSTY 0.1.0 u22.aarch64.pg14 : postgresql-14-convert postgresql-14-convert_0.1.0-3PIGSTY~jammy_arm64.deb PIGSTY · 0.1.0 · 656.2KiB
u24.x86_64	PIGSTY 0.1.0 u24.x86_64.pg18 : postgresql-18-convert postgresql-18-convert_0.1.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.1.0 · 741.7KiB	PIGSTY 0.1.0 u24.x86_64.pg17 : postgresql-17-convert postgresql-17-convert_0.1.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.1.0 · 739.1KiB	PIGSTY 0.1.0 u24.x86_64.pg16 : postgresql-16-convert postgresql-16-convert_0.1.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.1.0 · 739.1KiB	PIGSTY 0.1.0 u24.x86_64.pg15 : postgresql-15-convert postgresql-15-convert_0.1.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.1.0 · 731.8KiB	PIGSTY 0.1.0 u24.x86_64.pg14 : postgresql-14-convert postgresql-14-convert_0.1.0-3PIGSTY~noble_amd64.deb PIGSTY · 0.1.0 · 728.0KiB
u24.aarch64	PIGSTY 0.1.0 u24.aarch64.pg18 : postgresql-18-convert postgresql-18-convert_0.1.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.1.0 · 657.0KiB	PIGSTY 0.1.0 u24.aarch64.pg17 : postgresql-17-convert postgresql-17-convert_0.1.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.1.0 · 654.8KiB	PIGSTY 0.1.0 u24.aarch64.pg16 : postgresql-16-convert postgresql-16-convert_0.1.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.1.0 · 653.8KiB	PIGSTY 0.1.0 u24.aarch64.pg15 : postgresql-15-convert postgresql-15-convert_0.1.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.1.0 · 648.4KiB	PIGSTY 0.1.0 u24.aarch64.pg14 : postgresql-14-convert postgresql-14-convert_0.1.0-3PIGSTY~noble_arm64.deb PIGSTY · 0.1.0 · 647.3KiB
u26.x86_64	PIGSTY 0.1.0 u26.x86_64.pg18 : postgresql-18-convert postgresql-18-convert_0.1.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.1.0 · 737.6KiB	PIGSTY 0.1.0 u26.x86_64.pg17 : postgresql-17-convert postgresql-17-convert_0.1.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.1.0 · 735.4KiB	PIGSTY 0.1.0 u26.x86_64.pg16 : postgresql-16-convert postgresql-16-convert_0.1.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.1.0 · 735.5KiB	PIGSTY 0.1.0 u26.x86_64.pg15 : postgresql-15-convert postgresql-15-convert_0.1.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.1.0 · 727.9KiB	PIGSTY 0.1.0 u26.x86_64.pg14 : postgresql-14-convert postgresql-14-convert_0.1.0-3PIGSTY~resolute_amd64.deb PIGSTY · 0.1.0 · 724.8KiB
u26.aarch64	PIGSTY 0.1.0 u26.aarch64.pg18 : postgresql-18-convert postgresql-18-convert_0.1.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.1.0 · 656.1KiB	PIGSTY 0.1.0 u26.aarch64.pg17 : postgresql-17-convert postgresql-17-convert_0.1.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.1.0 · 652.6KiB	PIGSTY 0.1.0 u26.aarch64.pg16 : postgresql-16-convert postgresql-16-convert_0.1.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.1.0 · 652.4KiB	PIGSTY 0.1.0 u26.aarch64.pg15 : postgresql-15-convert postgresql-15-convert_0.1.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.1.0 · 646.9KiB	PIGSTY 0.1.0 u26.aarch64.pg14 : postgresql-14-convert postgresql-14-convert_0.1.0-3PIGSTY~resolute_arm64.deb PIGSTY · 0.1.0 · 645.2KiB

Build

You can build the RPM / DEB packages for pg_convert using pig build:

pig build pkg pg_convert         # build RPM / DEB packages

Install

You can install pg_convert directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

pig repo add pgsql -u          # Add repo and update cache

Install the extension using pig or apt/yum/dnf:

Install

pig install pg_convert;          # Install for current active PG version

pig

pig ext install -y pg_convert -v 18  # PG 18
pig ext install -y pg_convert -v 17  # PG 17
pig ext install -y pg_convert -v 16  # PG 16
pig ext install -y pg_convert -v 15  # PG 15
pig ext install -y pg_convert -v 14  # PG 14

dnf

dnf install -y pg_convert_18       # PG 18
dnf install -y pg_convert_17       # PG 17
dnf install -y pg_convert_16       # PG 16
dnf install -y pg_convert_15       # PG 15
dnf install -y pg_convert_14       # PG 14

apt

apt install -y postgresql-18-convert   # PG 18
apt install -y postgresql-17-convert   # PG 17
apt install -y postgresql-16-convert   # PG 16
apt install -y postgresql-15-convert   # PG 15
apt install -y postgresql-14-convert   # PG 14

Create Extension:

CREATE EXTENSION convert;

Usage

convert: common unit conversion functions for PostgreSQL

Provides functions for common unit conversions: distance, speed, time-to-travel, power, area, and temperature.

CREATE EXTENSION convert;

Distance Functions

Function	Description
`dist_mi_to_ft(miles)`	Miles to feet
`dist_ft_to_mi(feet)`	Feet to miles
`dist_ft_to_m(feet)`	Feet to meters
`dist_m_to_ft(meters)`	Meters to feet
`dist_m_to_km(meters)`	Meters to kilometers
`dist_km_to_m(km)`	Kilometers to meters
`dist_mi_to_km(miles)`	Miles to kilometers
`dist_m_to_mi(meters)`	Meters to miles
`dist_km_to_mi(km)`	Kilometers to miles

Speed Functions

Function	Description
`speed_mph_to_kmhr(mph)`	MPH to km/h
`speed_kmhr_to_mph(kmhr)`	km/h to MPH
`speed_kmhr_to_m_s(kmhr)`	km/h to m/s
`speed_mph_to_m_s(mph)`	MPH to m/s
`speed_m_s_to_kmhr(m_s)`	m/s to km/h
`speed_m_s_to_mph(m_s)`	m/s to MPH

Area Functions

Function	Description
`area_m2_to_km2(m2)`	sq meters to sq km
`area_m2_to_ft2(m2)`	sq meters to sq feet
`area_ft2_to_m2(ft2)`	sq feet to sq meters
`area_ft2_to_mi2(ft2)`	sq feet to sq miles
`area_mi2_to_ft2(mi2)`	sq miles to sq feet
`area_mi2_to_acre(mi2)`	sq miles to acres
`area_acre_to_mi2(acres)`	Acres to sq miles
`area_acre_to_km2(acres)`	Acres to sq km

Temperature Functions

Function	Description
`temp_c_to_f(celsius)`	Celsius to Fahrenheit
`temp_f_to_c(fahrenheit)`	Fahrenheit to Celsius

Power Functions

Function	Description
`power_dbm_to_watts(dbm)`	dBm to watts
`power_watts_to_dbm(watts)`	Watts to dBm

Examples

SELECT dist_mi_to_km(26.2);      -- 42.16 (marathon in km)
SELECT temp_f_to_c(98.6);         -- 37.0
SELECT speed_mph_to_kmhr(60.0);   -- 96.56
SELECT area_acre_to_km2(640.0);   -- ~2.59

convert

Overview

Version

Build

Install

Usage

Distance Functions

Speed Functions

Area Functions

Temperature Functions

Power Functions

Examples

Was this page helpful?