337
edits
Changes
Jump to navigation
Jump to search
(run * Run this command in a folder with all files for the table, such as files of type .shp, .dbf, .shx, .cpg, and .prj)(* "TIFDistrict.shp" is the name of the shapefile and dallstif is the name of the table I wish to name)(* Will be prompted for a password after running inputting this command)
→Command to upload SHP file into a table in database (tigertest)
== Command to upload SHP file into a table in database (tigertest) ==
researcher@McNairDBServ:/bulk/Jeemin/Dallas$ shp2pgsql -I "TIFDistrict.shp" dallastif | psql -U postgres -W -d tigertest
== To view all columns of a tale ==
