Procedure - insurance_premium_tax

Download the product delivery file.

Extract the delivery file to find the text data file.

Create the table structure in the database using the create table script. Be sure to change the table name in the template to the dataset you are loading. If, for example, you are loading a dataset for Insurance Premium Tax, the table should be named insurance_premium_tax.

Once the table structure has been created, copy data using the PostgreSQL Copy command:

copy <table_name> from '<path_to_text_file>\<text_file_name.txt>' delimiter '|' csv quote e'\b';

Syntax:

<table_name>: Name of table created using Create Table script

<path_to_text_file>: Path to extracted data text file

<text_file_name.txt>: Extracted data text file name, including file extension

delimiter: Defines the text delimiter (in this case, the pipe character)

csv quote e'/b': Specifies quoting

Example – Linux:

copy from '/mnr/Insurance_Premium_Tax/Insurance_Premium_Tax_Data/
Insurance_Premium_Tax.txt' delimiter '|' csv quote e'\b'

Example – Windows:

copy from 'F:\Insurance_Premium_Tax\Insurance_Premium_Tax_Data\
Insurance_Premium_Tax.txt' delimiter '|' csv quote e '\b'

Procedure - insurance_premium_tax - Latest

Geoenrichment Risk - Insurance Premium Tax Getting Started Guide