To import .TXT file into a PostgreSQL table using pgAdmin III - data_link_for_geox - Latest

1. 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.
2. Use pgAdmin GUI tool to import text file into a table in PostgreSQL server.
3. Right click on the table, choose the import.
4. Browse to the file, choose format as text or csv and set encoding to UTF8.
5. Click the Columns tab and ensure that all the columns are checked.
6. Check the Header checkbox in the Misc. tab.
7. Select the pipe character ( | ) as the delimiter and click Import.
8. Click Done when the import process finishes.