Res: Re: [postgis-users] dropping geometry tables

[Ezequias Rodrigues da Rocha]

I forgot the word "select" on the statement. Sorry and thank you.

Ezequias   
-------Mensagem original-------
 
De: Nicolas Ribot
Data: 07/29/05 10:19:35
Para: PostGIS Users Discussion
Assunto: Re: [postgis-users] dropping geometry tables
 
> I am sending a
>
>  DROPGeometryTable(['dbpotgis'],ezequias);
> or
>  DROPGeometryTable([dbpotgis],ezequias);
> or
>  DROPGeometryTable('dbpotgis',ezequias);
>
> Where dbpotgis is the database name (schema)
> and ezequias is the name of my geometry table.
>
> The error reported in all cases is: ERROR:  syntax error at or near
> DROPGeometryTable" at character 2
>
 
Hi,
You have to quote schema name and table name:
 
select dropGeometryColumn('dbpotgis', 'ezequias');
 
(the brackets [] in the documentation indicate optional parameters for
a function. In this case, meanning you can use dropGemetryTable() with
only one parameter: the table name).
 
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/20050729/3eb56dcd/attachment.html>