PostGIS Lesson 4 - Loading Non-spatial Data into PostGIS

[@pietgerrits90]

Thanks for the videos and all information. For this workflow, I would suggest also have a look at the QGIS Plugin: Spreadsheet layers. It will let you import .xlsx files directly (plugins.qgis.org/plugins/SpreadsheetLayers/) and then move to POSTGIS.

[@giswqs]

Good to know. Thanks for sharing.

[@StefanoVerugi]

csv too, no need for plugin, just select Add Delimited Text layer from Add Layer menu or ctrl shift T
this way you can check data type as well (But for Xlsx the plugin is the best)
you can also drag & drop layers directly from their pane into the database

[@ricardozaratesotelo8726]

Thanks for the video Mr. Wu. I have a question: if I have a lot of big data format "txt", how can I automatize the import table? I try to charge with batch process o pyqgis but it doesn't work. Do you recommend me an example or idea to solve my problem? Thanks in advance

[@abdoulayeleye5399]

Thanks for this work it's very powerful. But i am some problems when i try to import a csv file in my QGIS Desktop, the software Crash. It's not support a csv format. Thanks for helping me

[@tommyleespartan5640]

thanks for the video