[postgis-users] Removing shapefile from Postgres

Sandro Santilli 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:
> Hi,
> 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

                                       ~~ http://strk.keybit.net 

More information about the postgis-users mailing list