concept csv file in category postgis

This is an excerpt from Manning's book PostGIS in Action, Third Edition MEAP V13. Login to get full access to this book.

Importing a CSV file

Fastfoodmaps.com graciously provided us with a comma-delimited file of all fast-food restaurants circa 2005. To import a CSV file, you need to create a table beforehand. After quickly studying the CSV file, you can create a staging table: