Extensions
q3c

q3c

q3c : q3c sky indexing plugin

Overview

ID Extension Package Version Category License Language
1540
q3c
q3c
 2.0.1
GIS
GPL-2.0
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d-r
No
Yes
No
Yes
yes
no
Relationships
See Also
h3
pg_geohash
earthdistance
pg_sphere
postgis
postgis_topology
postgis_raster
postgis_sfcgal

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
MIXED
 2.0.1
18
17
16
15
14
13
 q3c -
RPM
PIGSTY
 2.0.1
18
17
16
15
14
13
 q3c_$v* -
DEB
PGDG
 2.0.1
18
17
16
15
14
13
 postgresql-$v-q3c -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
el8.aarch64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
el9.x86_64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
el9.aarch64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
el10.x86_64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
el10.aarch64
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
PIGSTY 2.0.1
d12.x86_64
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
d12.aarch64
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
d13.x86_64
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
d13.aarch64
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
u22.x86_64
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
u22.aarch64
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
u24.x86_64
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
u24.aarch64
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
PGDG 2.0.1
Package Version OS ORG SIZE File URL
q3c_18 2.0.1 el8.x86_64 pigsty 98.7 KiB q3c_18-2.0.1-1PIGSTY.el8.x86_64.rpm
q3c_18 2.0.1 el8.x86_64 pgdg 103.5 KiB q3c_18-2.0.1-1PGDG.rhel8.x86_64.rpm
q3c_18 2.0.1 el8.aarch64 pigsty 93.1 KiB q3c_18-2.0.1-1PIGSTY.el8.aarch64.rpm
q3c_18 2.0.1 el8.aarch64 pgdg 97.8 KiB q3c_18-2.0.1-1PGDG.rhel8.aarch64.rpm
q3c_18 2.0.1 el9.x86_64 pigsty 132.3 KiB q3c_18-2.0.1-1PIGSTY.el9.x86_64.rpm
q3c_18 2.0.1 el9.x86_64 pgdg 108.7 KiB q3c_18-2.0.1-1PGDG.rhel9.x86_64.rpm
q3c_18 2.0.1 el9.aarch64 pigsty 126.1 KiB q3c_18-2.0.1-1PIGSTY.el9.aarch64.rpm
q3c_18 2.0.1 el9.aarch64 pgdg 105.3 KiB q3c_18-2.0.1-1PGDG.rhel9.aarch64.rpm
q3c_18 2.0.1 el10.x86_64 pigsty 134.5 KiB q3c_18-2.0.1-1PIGSTY.el10.x86_64.rpm
q3c_18 2.0.1 el10.x86_64 pgdg 127.7 KiB q3c_18-2.0.1-1PGDG.rhel10.x86_64.rpm
q3c_18 2.0.1 el10.aarch64 pigsty 128.9 KiB q3c_18-2.0.1-1PIGSTY.el10.aarch64.rpm
q3c_18 2.0.1 el10.aarch64 pgdg 106.9 KiB q3c_18-2.0.1-1PGDG.rhel10.aarch64.rpm
postgresql-18-q3c 2.0.1 d12.x86_64 pgdg 140.8 KiB postgresql-18-q3c_2.0.1-5.pgdg12+1_amd64.deb
postgresql-18-q3c 2.0.1 d12.aarch64 pgdg 157.1 KiB postgresql-18-q3c_2.0.1-5.pgdg12+1_arm64.deb
postgresql-18-q3c 2.0.1 d13.x86_64 pgdg 138.9 KiB postgresql-18-q3c_2.0.1-5.pgdg13+1_amd64.deb
postgresql-18-q3c 2.0.1 d13.aarch64 pgdg 161.0 KiB postgresql-18-q3c_2.0.1-5.pgdg13+1_arm64.deb
postgresql-18-q3c 2.0.1 u22.x86_64 pgdg 153.8 KiB postgresql-18-q3c_2.0.1-5.pgdg22.04+1_amd64.deb
postgresql-18-q3c 2.0.1 u22.aarch64 pgdg 124.0 KiB postgresql-18-q3c_2.0.1-5.pgdg22.04+1_arm64.deb
postgresql-18-q3c 2.0.1 u24.x86_64 pgdg 155.3 KiB postgresql-18-q3c_2.0.1-5.pgdg24.04+1_amd64.deb
postgresql-18-q3c 2.0.1 u24.aarch64 pgdg 124.4 KiB postgresql-18-q3c_2.0.1-5.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
q3c_17 2.0.1 el8.x86_64 pigsty 98.7 KiB q3c_17-2.0.1-1PIGSTY.el8.x86_64.rpm
q3c_17 2.0.1 el8.x86_64 pgdg 103.5 KiB q3c_17-2.0.1-1PGDG.rhel8.x86_64.rpm
q3c_17 2.0.1 el8.aarch64 pigsty 93.1 KiB q3c_17-2.0.1-1PIGSTY.el8.aarch64.rpm
q3c_17 2.0.1 el8.aarch64 pgdg 97.8 KiB q3c_17-2.0.1-1PGDG.rhel8.aarch64.rpm
q3c_17 2.0.1 el9.x86_64 pigsty 132.3 KiB q3c_17-2.0.1-1PIGSTY.el9.x86_64.rpm
q3c_17 2.0.1 el9.x86_64 pgdg 101.8 KiB q3c_17-2.0.1-1PGDG.rhel9.x86_64.rpm
q3c_17 2.0.1 el9.aarch64 pigsty 126.9 KiB q3c_17-2.0.1-1PIGSTY.el9.aarch64.rpm
q3c_17 2.0.1 el9.aarch64 pgdg 105.4 KiB q3c_17-2.0.1-1PGDG.rhel9.aarch64.rpm
q3c_17 2.0.1 el10.x86_64 pigsty 105.7 KiB q3c_17-2.0.1-1PIGSTY.el10.x86_64.rpm
q3c_17 2.0.1 el10.x86_64 pgdg 127.7 KiB q3c_17-2.0.1-1PGDG.rhel10.x86_64.rpm
q3c_17 2.0.1 el10.aarch64 pigsty 100.4 KiB q3c_17-2.0.1-1PIGSTY.el10.aarch64.rpm
q3c_17 2.0.1 el10.aarch64 pgdg 107.7 KiB q3c_17-2.0.1-1PGDG.rhel10.aarch64.rpm
postgresql-17-q3c 2.0.1 d12.x86_64 pgdg 150.9 KiB postgresql-17-q3c_2.0.1-5.pgdg12+1_amd64.deb
postgresql-17-q3c 2.0.1 d12.aarch64 pgdg 159.7 KiB postgresql-17-q3c_2.0.1-5.pgdg12+1_arm64.deb
postgresql-17-q3c 2.0.1 d13.x86_64 pgdg 156.4 KiB postgresql-17-q3c_2.0.1-5.pgdg13+1_amd64.deb
postgresql-17-q3c 2.0.1 d13.aarch64 pgdg 158.3 KiB postgresql-17-q3c_2.0.1-5.pgdg13+1_arm64.deb
postgresql-17-q3c 2.0.1 u22.x86_64 pgdg 153.6 KiB postgresql-17-q3c_2.0.1-5.pgdg22.04+1_amd64.deb
postgresql-17-q3c 2.0.1 u22.aarch64 pgdg 165.4 KiB postgresql-17-q3c_2.0.1-5.pgdg22.04+1_arm64.deb
postgresql-17-q3c 2.0.1 u24.x86_64 pgdg 142.7 KiB postgresql-17-q3c_2.0.1-5.pgdg24.04+1_amd64.deb
postgresql-17-q3c 2.0.1 u24.aarch64 pgdg 144.2 KiB postgresql-17-q3c_2.0.1-5.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
q3c_16 2.0.1 el8.x86_64 pigsty 98.7 KiB q3c_16-2.0.1-1PIGSTY.el8.x86_64.rpm
q3c_16 2.0.1 el8.x86_64 pgdg 103.5 KiB q3c_16-2.0.1-1PGDG.rhel8.x86_64.rpm
q3c_16 2.0.1 el8.aarch64 pigsty 93.1 KiB q3c_16-2.0.1-1PIGSTY.el8.aarch64.rpm
q3c_16 2.0.1 el8.aarch64 pgdg 97.8 KiB q3c_16-2.0.1-1PGDG.rhel8.aarch64.rpm
q3c_16 2.0.1 el9.x86_64 pigsty 132.3 KiB q3c_16-2.0.1-1PIGSTY.el9.x86_64.rpm
q3c_16 2.0.1 el9.x86_64 pgdg 103.3 KiB q3c_16-2.0.1-1PGDG.rhel9.x86_64.rpm
q3c_16 2.0.1 el9.aarch64 pigsty 103.8 KiB q3c_16-2.0.1-1PIGSTY.el9.aarch64.rpm
q3c_16 2.0.1 el9.aarch64 pgdg 105.4 KiB q3c_16-2.0.1-1PGDG.rhel9.aarch64.rpm
q3c_16 2.0.1 el10.x86_64 pigsty 105.7 KiB q3c_16-2.0.1-1PIGSTY.el10.x86_64.rpm
q3c_16 2.0.1 el10.x86_64 pgdg 127.7 KiB q3c_16-2.0.1-1PGDG.rhel10.x86_64.rpm
q3c_16 2.0.1 el10.aarch64 pigsty 100.3 KiB q3c_16-2.0.1-1PIGSTY.el10.aarch64.rpm
q3c_16 2.0.1 el10.aarch64 pgdg 107.5 KiB q3c_16-2.0.1-1PGDG.rhel10.aarch64.rpm
postgresql-16-q3c 2.0.1 d12.x86_64 pgdg 134.7 KiB postgresql-16-q3c_2.0.1-5.pgdg12+1_amd64.deb
postgresql-16-q3c 2.0.1 d12.aarch64 pgdg 160.4 KiB postgresql-16-q3c_2.0.1-5.pgdg12+1_arm64.deb
postgresql-16-q3c 2.0.1 d13.x86_64 pgdg 159.1 KiB postgresql-16-q3c_2.0.1-5.pgdg13+1_amd64.deb
postgresql-16-q3c 2.0.1 d13.aarch64 pgdg 159.2 KiB postgresql-16-q3c_2.0.1-5.pgdg13+1_arm64.deb
postgresql-16-q3c 2.0.1 u22.x86_64 pgdg 160.8 KiB postgresql-16-q3c_2.0.1-5.pgdg22.04+1_amd64.deb
postgresql-16-q3c 2.0.1 u22.aarch64 pgdg 154.0 KiB postgresql-16-q3c_2.0.1-5.pgdg22.04+1_arm64.deb
postgresql-16-q3c 2.0.1 u24.x86_64 pgdg 149.6 KiB postgresql-16-q3c_2.0.1-5.pgdg24.04+1_amd64.deb
postgresql-16-q3c 2.0.1 u24.aarch64 pgdg 144.3 KiB postgresql-16-q3c_2.0.1-5.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
q3c_15 2.0.1 el8.x86_64 pigsty 97.6 KiB q3c_15-2.0.1-1PIGSTY.el8.x86_64.rpm
q3c_15 2.0.1 el8.x86_64 pgdg 102.3 KiB q3c_15-2.0.1-1PGDG.rhel8.x86_64.rpm
q3c_15 2.0.1 el8.aarch64 pigsty 92.7 KiB q3c_15-2.0.1-1PIGSTY.el8.aarch64.rpm
q3c_15 2.0.1 el8.aarch64 pgdg 97.2 KiB q3c_15-2.0.1-1PGDG.rhel8.aarch64.rpm
q3c_15 2.0.1 el9.x86_64 pigsty 160.3 KiB q3c_15-2.0.1-1PIGSTY.el9.x86_64.rpm
q3c_15 2.0.1 el9.x86_64 pgdg 109.3 KiB q3c_15-2.0.1-1PGDG.rhel9.x86_64.rpm
q3c_15 2.0.1 el9.aarch64 pigsty 107.3 KiB q3c_15-2.0.1-1PIGSTY.el9.aarch64.rpm
q3c_15 2.0.1 el9.aarch64 pgdg 103.5 KiB q3c_15-2.0.1-1PGDG.rhel9.aarch64.rpm
q3c_15 2.0.1 el10.x86_64 pigsty 134.0 KiB q3c_15-2.0.1-1PIGSTY.el10.x86_64.rpm
q3c_15 2.0.1 el10.x86_64 pgdg 92.2 KiB q3c_15-2.0.1-1PGDG.rhel10.x86_64.rpm
q3c_15 2.0.1 el10.aarch64 pigsty 128.1 KiB q3c_15-2.0.1-1PIGSTY.el10.aarch64.rpm
q3c_15 2.0.1 el10.aarch64 pgdg 104.1 KiB q3c_15-2.0.1-1PGDG.rhel10.aarch64.rpm
postgresql-15-q3c 2.0.1 d12.x86_64 pgdg 139.2 KiB postgresql-15-q3c_2.0.1-5.pgdg12+1_amd64.deb
postgresql-15-q3c 2.0.1 d12.aarch64 pgdg 158.9 KiB postgresql-15-q3c_2.0.1-5.pgdg12+1_arm64.deb
postgresql-15-q3c 2.0.1 d13.x86_64 pgdg 151.5 KiB postgresql-15-q3c_2.0.1-5.pgdg13+1_amd64.deb
postgresql-15-q3c 2.0.1 d13.aarch64 pgdg 125.4 KiB postgresql-15-q3c_2.0.1-5.pgdg13+1_arm64.deb
postgresql-15-q3c 2.0.1 u22.x86_64 pgdg 153.7 KiB postgresql-15-q3c_2.0.1-5.pgdg22.04+1_amd64.deb
postgresql-15-q3c 2.0.1 u22.aarch64 pgdg 164.1 KiB postgresql-15-q3c_2.0.1-5.pgdg22.04+1_arm64.deb
postgresql-15-q3c 2.0.1 u24.x86_64 pgdg 132.1 KiB postgresql-15-q3c_2.0.1-5.pgdg24.04+1_amd64.deb
postgresql-15-q3c 2.0.1 u24.aarch64 pgdg 146.3 KiB postgresql-15-q3c_2.0.1-5.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
q3c_14 2.0.1 el8.x86_64 pigsty 97.6 KiB q3c_14-2.0.1-1PIGSTY.el8.x86_64.rpm
q3c_14 2.0.1 el8.x86_64 pgdg 102.3 KiB q3c_14-2.0.1-1PGDG.rhel8.x86_64.rpm
q3c_14 2.0.1 el8.aarch64 pigsty 92.6 KiB q3c_14-2.0.1-1PIGSTY.el8.aarch64.rpm
q3c_14 2.0.1 el8.aarch64 pgdg 97.2 KiB q3c_14-2.0.1-1PGDG.rhel8.aarch64.rpm
q3c_14 2.0.1 el9.x86_64 pigsty 160.3 KiB q3c_14-2.0.1-1PIGSTY.el9.x86_64.rpm
q3c_14 2.0.1 el9.x86_64 pgdg 109.3 KiB q3c_14-2.0.1-1PGDG.rhel9.x86_64.rpm
q3c_14 2.0.1 el9.aarch64 pigsty 128.1 KiB q3c_14-2.0.1-1PIGSTY.el9.aarch64.rpm
q3c_14 2.0.1 el9.aarch64 pgdg 103.3 KiB q3c_14-2.0.1-1PGDG.rhel9.aarch64.rpm
q3c_14 2.0.1 el10.x86_64 pigsty 133.7 KiB q3c_14-2.0.1-1PIGSTY.el10.x86_64.rpm
q3c_14 2.0.1 el10.x86_64 pgdg 92.1 KiB q3c_14-2.0.1-1PGDG.rhel10.x86_64.rpm
q3c_14 2.0.1 el10.aarch64 pigsty 128.1 KiB q3c_14-2.0.1-1PIGSTY.el10.aarch64.rpm
q3c_14 2.0.1 el10.aarch64 pgdg 104.0 KiB q3c_14-2.0.1-1PGDG.rhel10.aarch64.rpm
postgresql-14-q3c 2.0.1 d12.x86_64 pgdg 143.4 KiB postgresql-14-q3c_2.0.1-5.pgdg12+1_amd64.deb
postgresql-14-q3c 2.0.1 d12.aarch64 pgdg 158.3 KiB postgresql-14-q3c_2.0.1-5.pgdg12+1_arm64.deb
postgresql-14-q3c 2.0.1 d13.x86_64 pgdg 148.8 KiB postgresql-14-q3c_2.0.1-5.pgdg13+1_amd64.deb
postgresql-14-q3c 2.0.1 d13.aarch64 pgdg 144.2 KiB postgresql-14-q3c_2.0.1-5.pgdg13+1_arm64.deb
postgresql-14-q3c 2.0.1 u22.x86_64 pgdg 163.5 KiB postgresql-14-q3c_2.0.1-5.pgdg22.04+1_amd64.deb
postgresql-14-q3c 2.0.1 u22.aarch64 pgdg 146.2 KiB postgresql-14-q3c_2.0.1-5.pgdg22.04+1_arm64.deb
postgresql-14-q3c 2.0.1 u24.x86_64 pgdg 150.9 KiB postgresql-14-q3c_2.0.1-5.pgdg24.04+1_amd64.deb
postgresql-14-q3c 2.0.1 u24.aarch64 pgdg 155.4 KiB postgresql-14-q3c_2.0.1-5.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
q3c_13 2.0.1 el8.x86_64 pigsty 97.3 KiB q3c_13-2.0.1-1PIGSTY.el8.x86_64.rpm
q3c_13 2.0.1 el8.x86_64 pgdg 102.1 KiB q3c_13-2.0.1-1PGDG.rhel8.x86_64.rpm
q3c_13 2.0.1 el8.aarch64 pigsty 92.6 KiB q3c_13-2.0.1-1PIGSTY.el8.aarch64.rpm
q3c_13 2.0.1 el8.aarch64 pgdg 97.2 KiB q3c_13-2.0.1-1PGDG.rhel8.aarch64.rpm
q3c_13 2.0.1 el9.x86_64 pigsty 160.3 KiB q3c_13-2.0.1-1PIGSTY.el9.x86_64.rpm
q3c_13 2.0.1 el9.x86_64 pgdg 111.1 KiB q3c_13-2.0.1-1PGDG.rhel9.x86_64.rpm
q3c_13 2.0.1 el9.aarch64 pigsty 112.2 KiB q3c_13-2.0.1-1PIGSTY.el9.aarch64.rpm
q3c_13 2.0.1 el9.aarch64 pgdg 103.3 KiB q3c_13-2.0.1-1PGDG.rhel9.aarch64.rpm
q3c_13 2.0.1 el10.x86_64 pigsty 133.9 KiB q3c_13-2.0.1-1PIGSTY.el10.x86_64.rpm
q3c_13 2.0.1 el10.x86_64 pgdg 92.1 KiB q3c_13-2.0.1-1PGDG.rhel10.x86_64.rpm
q3c_13 2.0.1 el10.aarch64 pigsty 128.1 KiB q3c_13-2.0.1-1PIGSTY.el10.aarch64.rpm
q3c_13 2.0.1 el10.aarch64 pgdg 104.0 KiB q3c_13-2.0.1-1PGDG.rhel10.aarch64.rpm
postgresql-13-q3c 2.0.1 d12.x86_64 pgdg 136.9 KiB postgresql-13-q3c_2.0.1-5.pgdg12+1_amd64.deb
postgresql-13-q3c 2.0.1 d12.aarch64 pgdg 156.1 KiB postgresql-13-q3c_2.0.1-5.pgdg12+1_arm64.deb
postgresql-13-q3c 2.0.1 d13.x86_64 pgdg 148.9 KiB postgresql-13-q3c_2.0.1-5.pgdg13+1_amd64.deb
postgresql-13-q3c 2.0.1 d13.aarch64 pgdg 155.4 KiB postgresql-13-q3c_2.0.1-5.pgdg13+1_arm64.deb
postgresql-13-q3c 2.0.1 u22.x86_64 pgdg 159.5 KiB postgresql-13-q3c_2.0.1-5.pgdg22.04+1_amd64.deb
postgresql-13-q3c 2.0.1 u22.aarch64 pgdg 161.4 KiB postgresql-13-q3c_2.0.1-5.pgdg22.04+1_arm64.deb
postgresql-13-q3c 2.0.1 u24.x86_64 pgdg 144.1 KiB postgresql-13-q3c_2.0.1-5.pgdg24.04+1_amd64.deb
postgresql-13-q3c 2.0.1 u24.aarch64 pgdg 149.9 KiB postgresql-13-q3c_2.0.1-5.pgdg24.04+1_arm64.deb

Source

Repository
github.com/segasai/q3c
 Source Tarball
q3c-2.0.1.tar.gz
 
pig build pkg q3c;		# build rpm / deb with pig

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgdg pigsty -u   # add both repo and update cache

Install this extension with pig:

pig install q3c;		# install via package name, for the active PG version

pig install q3c -v 18;   # install for PG 18
pig install q3c -v 17;   # install for PG 17
pig install q3c -v 16;   # install for PG 16
pig install q3c -v 15;   # install for PG 15
pig install q3c -v 14;   # install for PG 14
pig install q3c -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION q3c;
Last updated on
h3_postgisogr_fdw