I use shp2pgsql to append a shapefile to an existing table.
How can I define the table where I want to append the shapefile in PostGIS?
This is the command I execute with Python:
command = "shp2pgsql -s 4326 -a shape_file.shp | psql -h localhost -p 5432 -d gis_exercise -U postgres"
But this commands generates a table with the name of the shapefile.