Geolocation Metadata
Learn how to locate an IP address in PostgreSQL.
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 google.us has the address 74.125.195.147, and we can inquire where that IP is from:
Access this course and 1400+ top-rated courses and projects.