Note: The following procedure uses Consumer Spend Potential as an
example in command syntax. All other GeoEnrichment Demographics datasets can be
uploaded by following the same steps and substituting the appropriate dataset name.
- Download the product delivery file.
- Extract the delivery file and find the text data file.
- Create the table structure in the database using the product-specific 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 the Consumer Spend dataset, the table should be named consumer_spend.
- Once the table structure has been created, copy data using the PostgreSQL Copy command:
copy <Table_name> from program 'cmd /c "type <FILE PATH>"' with
(format csv ,delimiter '|',header true)Syntax:
<table_name>: Name of the table created using Create Table
script.
<path_to_text_file>: Path to extracted data 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 groundview_consumer_spend_dataset1_cy_attribute from program
'cmd /c "type ’mnr/GROUNDVIEW_COMPLETE_USA_2025_TXT/data
/geoenrichment/ge_gv_usa_consumer_spend1_cy.txt"'
with (format csv ,delimiter '|',header true)Example – Windows:
copy groundview_consumer_spend_dataset1_cy_attribute from program
'cmd /c "type E:\GROUNDVIEW_COMPLETE_USA_2025_TXT\data
\geoenrichment\ge_gv_usa_consumer_spend1_cy.txt"'
with (format csv ,delimiter '|',header true)