Res: Re: [postgis-users] How to drop a PostGIS table ?

[Ezequias Rodrigues da Rocha]

Thank you Nicolas. 
 
-------Mensagem original-------
 
De: Nicolas Ribot
Data: 07/12/05 14:40:56
Para: PostGIS Users Discussion
Assunto: Re: [postgis-users] How to drop a PostGIS table ?
 
>
>  Hello,
>
> I would like how to drop a PostGIS table on Postgresql.
>
> Does anyone knows how to drop it and all the relations on the tables  
spatial_ref_sys" and "geometry_columns"
>
>
 
Hi Ezequias,
 
There is a function that does the trick (as stated in the documentation) :
 
"DropGeometryTable([<schema_name>], <table_name>)
 
    Drops a table and all its references in geometry_columns. Note:
uses current_schema() on schema-aware pgsql installations if schema is
not provided."
 
Nicolas
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050712/08de003d/attachment.html>