import and export shapefiles into database using command pormpt || shp2pgsql || pgsql2shp || tekson

preview_player
Показать описание
In this video, I explain process of import and export shapefiles using command prompt. The code shp2pgsql and pgsql2shp are used in this code.
Рекомендации по теме
Комментарии
Автор

Hello thanks for the tutorial. I have one question. where do I find Edit environment variable window in pgadmin4? thanks

raiyans
Автор

При попытке импорта, получал ошибку dbf file can not be opened. Решением оказалось: Путь должен состоять только латиницей(на английском), без пробелов и кириллицы

ЭльдарМустафутдинов
Автор

Spent two days trying to figure out why it can't see the file even if CMD is run as administrator in the directory where the file is ".shp"

FAILURE: no source datasource provided

ogr2ogr -append -f PG:"dbname=nyc host=%localhost% user=postgres password=%PGPASSWORD% port=5432" nyc_census_blocks_2000.shp -nln nyc_census_blocks_2000 -nlt PROMOTE_TO_MULTI -lco GEOMETRY_NAME=geom -lco FID=gid -lco PRECISION=NO

googleadmin