Geolocation Metadata
Explore how to use PostgreSQL and the MaxMind geolocation schema to locate IP addresses. Understand querying techniques that return geographic data, including country, city, and precise coordinates. This lesson helps you perform geolocation lookups and visualize location data with point data types.
We'll cover the following...
We'll cover the following...
Locating an IP address
Now with the MaxMind schema, the interesting data is actually to be found in the other table (i.e., geolite.location). Let’s use another IP address now—we’re told by the UNIX command host that ...