<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="IncrediMail 1.0" name=GENERATOR></HEAD>
<BODY style="BACKGROUND-POSITION: 0px 0px; FONT-SIZE: 12pt; MARGIN: 5px 10px 10px; FONT-FAMILY: Arial" bgColor=#ffffff background="" scroll=yes ORGYPOS="0">
<TABLE id=INCREDIMAINTABLE cellSpacing=0 cellPadding=2 width="100%" border=0>
<TBODY>
<TR>
<TD id=INCREDITEXTREGION style="FONT-SIZE: 12pt; CURSOR: auto; FONT-FAMILY: Arial" width="100%">
<DIV>I forgot the word "select" on the statement. Sorry and thank you.</DIV>
<DIV> </DIV>
<DIV>Ezequias </DIV>
<DIV id=IncrediOriginalMessage><I>-------Mensagem original-------</I></DIV>
<DIV> </DIV>
<DIV id=receivestrings>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>De:</B></I> <A href="mailto:nicky666@gmail.com">Nicolas Ribot</A></DIV>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>Data:</B></I> 07/29/05 10:19:35</DIV>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>Para:</B></I> <A href="mailto:postgis-users@postgis.refractions.net">PostGIS Users Discussion</A></DIV>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>Assunto:</B></I> Re: [postgis-users] dropping geometry tables</DIV></DIV>
<DIV> </DIV>
<DIV>> I am sending a</DIV>
<DIV>></DIV>
<DIV>> DROPGeometryTable(['dbpotgis'],ezequias);</DIV>
<DIV>> or</DIV>
<DIV>> DROPGeometryTable([dbpotgis],ezequias);</DIV>
<DIV>> or</DIV>
<DIV>> DROPGeometryTable('dbpotgis',ezequias);</DIV>
<DIV>></DIV>
<DIV>> Where dbpotgis is the database name (schema)</DIV>
<DIV>> and ezequias is the name of my geometry table.</DIV>
<DIV>></DIV>
<DIV>> The error reported in all cases is: ERROR: syntax error at or near</DIV>
<DIV>> DROPGeometryTable" at character 2</DIV>
<DIV>></DIV>
<DIV> </DIV>
<DIV>Hi,</DIV>
<DIV>You have to quote schema name and table name:</DIV>
<DIV> </DIV>
<DIV>select dropGeometryColumn('dbpotgis', 'ezequias');</DIV>
<DIV> </DIV>
<DIV>(the brackets [] in the documentation indicate optional parameters for</DIV>
<DIV>a function. In this case, meanning you can use dropGemetryTable() with</DIV>
<DIV>only one parameter: the table name).</DIV>
<DIV> </DIV>
<DIV>Nicolas</DIV>
<DIV>_______________________________________________</DIV>
<DIV>postgis-users mailing list</DIV>
<DIV><A href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A></DIV>
<DIV><A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></DIV></TD></TR>
<TR>
<TD id=INCREDIFOOTER width="100%">
<TABLE cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD width="100%"></TD>
<TD id=INCREDISOUND vAlign=bottom align=middle></TD>
<TD id=INCREDIANIM vAlign=bottom align=middle></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><SPAN id=IncrediStamp><SPAN dir=ltr><A href="http://www.incredimail.com/index.asp?id=54760"><IMG alt="Add FUN to your email - CLICK HERE!" hspace=0 src="http://www2.incredimail.com/contents/stamps/imstp_emo_pt.gif" align=baseline border=0></A></SPAN></SPAN></BODY></HTML>