Saturday 29 December 2018

postgis - shp2pgsql: how to know the schema.table?


I want to import a shapefile using shp2pgsql. I am using Mac with Postgis 2.2.


Based on this reference: A conversion and upload can be done all in one step using a UNIX pipe:


  shp2pgsql -s  -c -D -I   | \
psql -d -h -U

An example provided in the postgis manual is:



# shp2pgsql shaperoads myschema.roadstable | psql -d roadsdb

Not sure how to find "schema.table". I am working on a shapefile folder which has:


l_2015_us_county yan$ ls
tl_2015_us_county.cpg tl_2015_us_county.prj tl_2015_us_county.shp.ea.iso.xml tl_2015_us_county.shp.xml
tl_2015_us_county.dbf tl_2015_us_county.shp tl_2015_us_county.shp.iso.xml tl_2015_us_county.shx

What is the schema and table in this shapefile?



Answer



The schema and table are part of the destination, not the input shapefile. The default schema is public, so try something like public.awesometable.



No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...