- Download the product delivery file
- Extract the delivery file and find the data text file
- Open the EMEA Address Fabric™ Data Create Table script in a text editor and confirm that the table name is set to emea_AddressFabric
- Run the Create Table script
- After the table structure has been created, copy data using the PostgreSQL Copy
command:
copy emea_address_fabric from program 'cmd /c "type <path of data file>"' with (format csv ,delimiter '|',header true)The following alternate syntax can be used if the data doesn't load using the command above:
Syntax:copy emea_address_fabric from program 'cmd /c "type <path of data file>"' with (format csv ,delimiter e'|',header true)<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, delimiter is tab)
e'|': Specifies alternate quoting for pipe delimiter
Example:copy emea_address_fabric from program 'cmd /c "type 'F:\emea_Address_Fabric\ emea_address_fabric_san_francisco.txt"' with (format csv ,delimiter '|',header true)Alternate command:
copy emea_address_fabric from program 'cmd /c "type 'F:\emea_Address_Fabric\ emea_address_fabric_san_francisco.txt"' with (format csv ,delimiter e'|',header true)