- h3 4.0.0
- PostgreSQL bindings for H3
PostgreSQL bindings for H3
Developed in collaboration with Scandinavian Highlands.
- PostgreSQL 9.6 or higher (including server headers). It might work with earlier versions, we have not tested earlier than 9.6.
- C compiler (e.g., gcc)
- GNU Make
- Git & CMake (for libh3)
If the prerequisites are met you can use the PGXN Client to download, build, and install, e.g.:
```shell $ pgxn install h3 $ pgxn load h3 $ psql =# SELECT h3_geo_to_h3(POINT('37.3615593,-122.0553238'), 5);
85e35e73fffffff (1 row) ```
On macOS with the Postgres.app Universal Binary
brew install pgxnclient make cmake
pgxn install h3
:tada: Note: The following usage docs apply to H3 v4, which was released on August 23, 2022.
Generally, all functions have been renamed from camelCase in H3 to snake*case in SQL with an added
See API reference for all provided functions.
This project is released under the Apache 2.0 License.