337
edits
Changes
Jump to navigation
Jump to search
→Uploading TIF Data onto database (tigertest)
researcher@McNairDBServ:/bulk/tigertest$ ogr2ogr -f PostgreSQL PG:"dbname=tigertest" chicagotif.kml -nln chicagotif
(chicagotif.kml is the name of the KML file and chicagotif is the name I wish to name the table)
== 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
(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)
== To view all columns of a tale ==
