[postgis-users] Removing shapefile from Postgres

[Sandro Santilli]

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

--strk;

 http://www.cartodb.com - Map, analyze and build applications with your data

                                       ~~ http://strk.keybit.net