
<HTML><BODY DEFANGED_STYLE="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><BR><DIV><DIV>On Oct 18, 2005, at 6:22 PM, Hamish wrote:</DIV><BR class="Apple-interchange-newline"><BLOCKQUOTE type="cite"><P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">but again, a fairly cruddy solution. Is there a SQL command that could<SPAN class="Apple-converted-space"> </SPAN></FONT></P> <P DEFANGED_STYLE="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" style="font: 12.0px Helvetica">be passed to db.execute?</FONT></P></BLOCKQUOTE><DIV><BR class="khtml-block-placeholder"></DIV><DIV>postgres uses something like this:</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><FONT class="Apple-style-span" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.8px;">ALTER TABLE products ADD COLUMN description text;</SPAN></FONT></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><FONT class="Apple-style-span" face="Courier" size="4"><SPAN class="Apple-style-span" style="font-size: 13.8px;">ALTER TABLE products DROP COLUMN description;</SPAN></FONT></DIV><DIV><BR class="khtml-block-placeholder"></DIV><BR><BLOCKQUOTE type="cite"> <P DEFANGED_STYLE="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px"><BR></P> <P DEFANGED_STYLE="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px"><BR></P> <P style="margin: 0.0px 0.0px 0.0px 0.0px"><FONT face="Helvetica" size="3" DEFANGED_STYLE="font: 12.0px Helvetica">Hamish</FONT></P> <BR class="Apple-interchange-newline"></BLOCKQUOTE></DIV><BR></BODY></HTML>