10
PGOpen 2018 Data Loading Presentation Slides
source link: https://www.postgresonline.com/journal/index.php?%2Farchives%2F391-PGOpen-2018-Data-Loading-Presentation-Slides_html=
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Sunday, September 09. 2018
PGOpen 2018 Data Loading Presentation Slides
Printer FriendlyAt PGOpen 2018 in San Francisco, we gave a talk on 10 ways to load data into Posgres. This is one of the rare talks where we didn't talk much about PostGIS. However we did showcase tools ogr_fdw, ogr2ogr, shp2pgsql, which are commonly used for loading spatial data, but equally as good for loading non-spatial data. Below are the slide links.
Comments
Display comments as
(Linear | Threaded)
Great summary, Thanks!
The slides state ogr_fdw can read dBase files (not part of a shapefile). Using ogr_fdw_info -f I do not see the format for that. Have you done that?
The slides state ogr_fdw can read dBase files (not part of a shapefile). Using ogr_fdw_info -f I do not see the format for that. Have you done that?
Yes I have. You would use the ESRI Shapefile driver to load them.
I think that might not work with FoxPro (new versions) so for those you might have to use the ODBC driver especially if they have memo fields.
I think that might not work with FoxPro (new versions) so for those you might have to use the ODBC driver especially if they have memo fields.
Add Comment
Name
Email
Homepage
In reply to
Comment
Subscribe to this entry
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
Enter the string from the spam-prevention image above:
Remember Information?
Enter the string from the spam-prevention image above:
Subscribe to this entry
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK