[postgis-users] Removing shapefile from Postgres
strk at keybit.net
Thu Nov 22 06:24:25 PST 2012
On Wed, Nov 21, 2012 at 05:43:34PM -0700, Smaran Harihar wrote:
> I added a shapefile to the PostGIS using,
> ogr2ogr -f PostgreSQL PG:"host=server_ip user=username dbname=dbname
> password=password" yourshapefile.shp;
> Now I want to remove it. What is the command line code for that?
Assuming the table created by ogr2ogr is named "yourshapefile"
(which you should verify) the call would be:
echo "SELECT DropGeometryTable('yourshapefile')" | psql -U username dbname
http://www.cartodb.com - Map, analyze and build applications with your data
More information about the postgis-users