Create Table

CREATE DATABASE ip2proxy
GO

USE ip2proxy
GO

CREATE TABLE [ip2proxy].[dbo].[ip2proxy_px9](
	[ip_from] char(39) NOT NULL,
	[ip_to] char(39) NOT NULL,
	[proxy_type] nvarchar(3) NOT NULL,
	[country_code] nvarchar(2) NOT NULL,
	[country_name] nvarchar(64) NOT NULL,
	[region_name] nvarchar(128) NOT NULL,
	[city_name] nvarchar(128) NOT NULL,
	[isp] nvarchar(256) NOT NULL,
	[domain] nvarchar(128) NOT NULL,
	[usage_type] nvarchar(11) NOT NULL,
	[asn] integer NOT NULL,
	[as] nvarchar(256) NOT NULL,
	[last_seen] integer NOT NULL,
	[threat] nvarchar(128) NOT NULL,
) ON [PRIMARY]
GO

CREATE CLUSTERED INDEX [ip_to] ON [ip2proxy].[dbo].[ip2proxy_px9]([ip_from], [ip_to]) ON [PRIMARY]
GO

Import Database

BULK INSERT [ip2proxy].[dbo].[ip2proxy_px9]
	FROM 'C:\PATH_TO_YOUR_CSV_FILE\IP-PROXYTYPE-COUNTRY-REGION-CITY-ISP-DOMAIN-USAGETYPE-ASN-LASTSEEN-THREAT.CSV'
	WITH
	(
		FORMATFILE = 'C:\PATH_TO_YOUR_PX9.FMT_FILE\PX9.FMT'
	)
GO

PX9.FMT

10.0
15
1	SQLCHAR	0	1	"\""	0	first_double_quote	Latin1_General_CI_AI
2	SQLCHAR	0	39	"\",\""	1	ip_from	""
3	SQLCHAR	0	39	"\",\""	2	ip_to	""
4	SQLCHAR	0	3	"\",\""	3	proxy_type	Latin1_General_CI_AI
5	SQLCHAR	0	2	"\",\""	4	country_code	Latin1_General_CI_AI
6	SQLCHAR	0	64	"\",\""	5	country_name	Latin1_General_CI_AI
7	SQLCHAR	0	128	"\",\""	6	region_name	Latin1_General_CI_AI
8	SQLCHAR	0	128	"\",\""	7	city_name	Latin1_General_CI_AI
9	SQLCHAR	0	256	"\",\""	8	isp	Latin1_General_CI_AI
10	SQLCHAR	0	128	"\",\""	9	domain	Latin1_General_CI_AI
11	SQLCHAR	0	11	"\",\""	10	usage_type	Latin1_General_CI_AI
12	SQLCHAR	0	10	"\",\""	11	asn	""
13	SQLCHAR	0	256	"\",\""	12	as	Latin1_General_CI_AI
14	SQLCHAR	0	10	"\",\""	13	last_seen	""
15	SQLCHAR	0	128	"\"\n"	14	threat	Latin1_General_CI_AI

Create Table

CREATE DATABASE ip2proxy WITH ENCODING 'UTF8';
\c ip2proxy
CREATE TABLE ip2proxy_px9(
	ip_from decimal(39,0) NOT NULL,
	ip_to decimal(39,0) NOT NULL,
	proxy_type character varying(3) NOT NULL,
	country_code character(2) NOT NULL,
	country_name character varying(64) NOT NULL,
	region_name character varying(128) NOT NULL,
	city_name character varying(128) NOT NULL,
	isp character varying(256) NOT NULL,
	domain character varying(128) NOT NULL,
	usage_type character varying(11) NOT NULL,
	asn character integer(10) NOT NULL,
	as character varying(256) NOT NULL,
	last_seen integer(10) NOT NULL,
	threat character varying(128) NOT NULL,
	CONSTRAINT ip2proxy_px9_pkey PRIMARY KEY (ip_from, ip_to)
);

Import Database

COPY ip2proxy_pxpx9 FROM 'IP-PROXYTYPE-COUNTRY-REGION-CITY-ISP-DOMAIN-USAGETYPE-ASN-LASTSEEN-THREAT.CSV' WITH CSV QUOTE AS '"';