Populating the table - Latest

Import the data from the PSQL prompt, specifying the correct path of the uncompressed *.txt product file. Replace path/to/Property_Graph_USA_CLASSx.txt with the actual path in which the product file is stored:

copy my_schema.property_graph_202301_classx (class, primary_key, secondary_key, type, state) FROM 'path/to/Property_Graph_USA_CLASSx.txt' DELIMITER ' | ' CSV HEADER;

Repeat this procedure for all files in the product.

All of the tables in Property Graph can be combined into a single table using syntax similar to the following:

SELECT class, primary_key, secondary_key, type FROM my_schema.property_graph_202301_class1 UNION SELECT class, primary_key_secondary_key, type FROM my_schema.property_graph_202301_class2