[postgis-users] dropping geometry tables

[Nicolas Ribot]

> 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