[postgis-users] dropping geometry tables

[Jean David TECHER]

Hi

It is very easy to find the solution. :-)

You forgot to add 'select' before dropgeoemtrytable!

dbpotgis-# select DropGeometryTable('ezequias');

and not

dbpotgis-# DropGeometryTable('ezequias');
---------------------------------------------------------------
TECHER Jean David
01MAP
e-mail: david at 01map.net
Tél: 04 67 45 60 27
Entreprise: http://www.01map.net
Perso: http://techer.pascal.free.fr/postgis/
---------------------------------------------------------------
  ----- Original Message ----- 
  From: Ezequias Rodrigues da Rocha 
  To: Nicolas Ribot ; PostGIS Users Discussion 
  Sent: Friday, July 29, 2005 3:44 PM
  Subject: Res: Re: [postgis-users] dropping geometry tables


        Thank you, but:

        dbpotgis-# DropGeometryTable('ezequias');
        ERROR:  syntax error at or near "DropGeometryTable" at character 1
        dbpotgis=#
         

        -------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 
               
       



------------------------------------------------------------------------------


  _______________________________________________
  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/6a2a7d2e/attachment.html>