Create Table

CREATE DATABASE ip2proxy
GO

USE ip2proxy
GO

CREATE TABLE [ip2proxy].[dbo].[ip2proxy_px4](
	[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,
) ON [PRIMARY]
GO

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

Import Database

BULK INSERT [ip2proxy].[dbo].[ip2proxy_px4]
	FROM 'C:\PATH_TO_YOUR_CSV_FILE\IP-PROXYTYPE-COUNTRY-REGION-CITY-ISP.CSV'
	WITH
	(
		FORMATFILE = 'C:\PATH_TO_YOUR_PX4.FMT_FILE\PX4.FMT'
	)
GO

PX4.FMT

10.0
9
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	"\"\n"	8	isp	Latin1_General_CI_AI

Create Table

CREATE DATABASE ip2proxy WITH ENCODING 'UTF8';
\c ip2proxy
CREATE TABLE ip2proxy_px4(
	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,
	CONSTRAINT ip2proxy_px4_pkey PRIMARY KEY (ip_from, ip_to)
);

Import Database

COPY ip2proxy_pxpx4 FROM 'IP-PROXYTYPE-COUNTRY-REGION-CITY-ISP.CSV' WITH CSV QUOTE AS '"';