Loading Property Historical Sales Field Value Key Data - property_historical_sales - Latest

Create the table structure in the database using the Create Table script. Be sure to change the table name in the template to hist_field_value_key.

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

<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

copy hist_field_value_key from ‘D:\Property_Historical_Sales\
Property_Historical_Sales_Data\property_historical_sales_field_value_key_usa.txt'delimiter'|'
csv quote e'\b';

copy hist_field_value_key from ‘D:/Property_Historical_Sales./
Property_Historical_Sales_Data/property_historical_sales_field_value_key_usa.txt'delimiter'|'
csv quote e'\b';