[GRASSLIST:9719] Re: drop column?

[Glynn Clements]

M S wrote:

> > >is there a drop column command? i didnt see one in the man pages, and
> > >when i tried the    "ALTER TABLE table DROP COLUMN column_name" |
> > >db.execute   it didnt like that command but i was able to add
> > >columns..
> > >
> > >
> > >
> > It depends on the DB driver. I assume that you use DBF? Then it doesn't
> > work since DBF is very limited. For all other drivers it should (untested).
> 
> yes sorry, that was for the DBF driver.  shoot, thats too bad.  i
> guess i'd have to (from reading the archives) create a temp table and
> copy over only the colums I want and then re-attach it?  that might be
> a handy function.
> 
> anyhow, learning postgres is on my TODO list, so hopefully this issue
> goes away with more knowledge.

If you want a reasonbly full SQL implementation without the complexity
of managing a database server, use SQLite.

SQLite is similar to DBF, in that it doesn't use a separate database
server and doesn't require configuration, but it implements much more
of the SQL standard.

-- 
Glynn Clements <glynn at gclements.plus.com>