PostgreSQL friendly IPinfodb SQL import

by tokumine

Title says it all really. I finally got tired of importing the ipinfodb into postgreSQL via CSV (the SQL they provide on their site targets MySQL), and have made a dump available on S3. Knock yourself out.

http://stokumine.s3.amazonaws.com/ipinfodb_one_table_small_pgsql.sql.gz

to use:

psql -U[your_user] [your_db] < ipinfodb_one_table_small_pgsql.sql

creates a table called geo_ips

Advertisements