[postgis-users] Removing shapefile from Postgres

[Basil Veerman]

Smaran,

Provided the remote server has an X11 server installed, X11 forwarding 
enabled, and X11 authentication, you can just 'ssh -X <remote-server>' 
to forward the gui of any X application to your local machine.

Here is some additional information: 
http://unix.stackexchange.com/questions/12755/how-to-forward-x-over-ssh-from-ubuntu-machine

Cheers,
Basil Veerman


On 12-11-22 06:13 AM, Smaran Harihar wrote:
>
> Thanks for the reply Jose. The only problem is I am working on Remote 
> Ubuntu Server and do not have a GUI. So not sure how to access the 
> PGAdminIII?
>
> On Nov 22, 2012 1:30 AM, "José Pedro Santos" <zpsantos1 at hotmail.com 
> <mailto:zpsantos1 at hotmail.com>> wrote:
>
>     Hi Smaran,
>
>     To import shp to Postgresql by command line is shp2pgsql. ogr2ogr
>     converts simple features data between file formats I don't advise
>     to use this one.
>
>     I never remove from command line just go to pgadmin and delete.
>
>     Regards,
>     Jose Santos
>
>     ------------------------------------------------------------------------
>     From: smaran.harihar at gmail.com <mailto:smaran.harihar at gmail.com>
>     Date: Wed, 21 Nov 2012 17:43:34 -0700
>     To: postgis-users at postgis.refractions.net
>     <mailto:postgis-users at postgis.refractions.net>
>     Subject: [postgis-users] Removing shapefile from Postgres
>
>     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?
>
>     -- 
>     Thanks & Regards
>     Smaran Harihar
>
>
>     _______________________________________________ postgis-users
>     mailing list postgis-users at lists.osgeo.org
>     <mailto:postgis-users at lists.osgeo.org>
>     http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>     _______________________________________________
>     postgis-users mailing list
>     postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
>     http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121122/02a2605d/attachment.html>