select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Geospatial

geoip2lookup

Look up IP-address info in MaxMind GeoIP2 MMDB files

pgext.cloud · Source code · Documentation · License text · Control file · PGXN

Overview

Packagegeoip2lookup
Version0.0.3
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemageoip2lookup
Stars4
Latest commit2017-09-13
Latest release2017-09-13
Catalogue updated2026-08-30

Related extensions

Requires

plperluPL/PerlU untrusted procedural language

See also

address_standardizerUsed to parse an address into constituent elements. Generally used to support geocoding address normalization step.
emailaddrEmail address type for PostgreSQL
addressing_dictionaryAddress handling dictionaries for PostgreSQL, applying smarter handling to addresses in text search.
emailEmail address data type with validation, equality operators, and user/domain helper functions.
pg_addressExtension creates composite type to store address
connection_limitsEnforce connection quotas by user, database, source IP or hostname, including combined rules.
cidrTransform an IPv4 or IPv6 address range into the minimal set of CIDR blocks
bfnRust/pgrx utility extension with UUID, date, string, JSON/address, and validation helper functions.