Joao Paulo Felix <felix@cyclades.com> writes:
> 1) Good books/reference on PostgreSQL for a novice?
I've no particular SQL book to recommend, although I hear much good
about Joe Celco's "SQL for Smarties". For a very good online
tutorial, check out <http://w3.one.net/~jhoffman/sqltut.htm>.
> 2) How do I delete a columm from a table, I have tried to use the
> following:
>
> DELETE FROM table_name columm_name
That should be
alter table table_name drop column column_name;
However, it's not yet implemented. You might rename the table, create
a new one lacking the offending column, and copy the data over. On
the other hand, you might just not worry about it. That's one of the
great things about SQL: if you can take the space consumption hit, an
extraneous column doesn't matter. Just don't "select *", which you
normally shouldn't do anyway.
-tih
--
Popularity is the hallmark of mediocrity. --Niles Crane, "Frasier"