Loading Canada Address Fabric™ Data Change Log - address_fabric_1

Important: These scripts support data until February 2025 (2025.02) release. Canada Address Fabric™ data follows Global Address Fabric schema from 2025.05 release onwards.

Download the product delivery file
Extract the delivery file and find the data text file
Open the Canada Address Fabric™ Data Change Log Create Table script in a text editor and confirm that the table name is set to CA_AddressFabric_ChangeLog
Run the Create Table script
After the table structure has been created, copy data using the PostgreSQL Copy command:
```
copy can_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:
```
copy can_address_fabric from program 'cmd /c "type <path of data file>"' with (format csv ,delimiter e'\t',header true)
```
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, delimiter is tab)

e'/t': Specifies alternate quoting for tab delimiter
Example:
```
copy can_address_fabric from program 'cmd /c "type 'F:\can_Address_Fabric\
can_address_fabric_changelog_toronto.txt"' with (format csv ,delimiter '	',header true)
```
Alternate command:
```
copy can_address_fabric from program 'cmd /c "type 'F:\can_Address_Fabric\
can_address_fabric_changelog_toronto.txt"' with (format csv ,delimiter e'\t',header true)
```

Loading Canada Address Fabric™ Data Change Log - address_fabric_1 - Latest

Address Fabric™ Data Getting Started Guide