I am using the following ogr2ogr command for putting my shapefiles into PostgreSQL table. This command runs fine.
ogr2ogr.exe -append -lco GEOMETRY_NAME=geom -lco SCHEMA=public -f "PostgreSQL" PG:"host=localhost port=5433 user=postgres dbname=abc123 password=xxxxxx" myshapefile.shp -nln shapetable
Now I want is to add extra field/fields like (countryName=xyz / RoadName= street123/etc) while using the above command when exporting my shapefile to PostgreSQL table.
I was trying to find the answer in another link but it was for adding extra field while exporting GeoJSON into PostgreSQL table.
Best Answer
Read the ogr2ogr documentation http://www.gdal.org/ogr2ogr.html, especially section about -addfields
If this method does not suit you it is always possible to alter the schema with ogrinfo