To import .TXT file into a PostgreSQL table using pgAdmin III - data_link_for_geox - Latest
Data Link for GeoX Getting Started Guide
- Product type
- Data
- Portfolio
- Enrich
- Product family
- Enrich Data Link
- Product
- Data Link for GeoX
- Version
- Latest
- ft:locale
- en-US
- Product name
- Data Link for GeoX
- ft:title
- Data Link for GeoX Getting Started Guide
- Copyright
- 2026
- First publish date
- 2025
- ft:lastEdition
- 2026-06-15
- ft:lastPublication
- 2026-06-15T05:47:26.317000
- L1_Product_Gateway
- Enrich
- L2_Product_Segment
- Data
- L3_Product_Brand
- Precisely Properties
- L4_Investment_Segment
- Precisely Addresses
- L5_Product_Group
- Property Features
- L6_Product_Name
- Data Link Addresses
- Create the table structure in the database using the create table script. Make sure to
change the table name in the template to the country for which you are loading the data.
- Use pgAdmin GUI tool to import text file into a table in PostgreSQL server.
- Right click on the table, choose the import.
- Browse to the file, choose format as text or csv and set encoding
to UTF8.
- Click the Columns tab and ensure that all the columns are checked.
- Check the Header checkbox in the Misc. tab.
- Select the pipe character ( | ) as the delimiter and click Import.
- Click Done when the import process finishes.