ALTER TABLE DROP COLUMN

From: glenn <vmstech(at)tpg(dot)com(dot)au>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: ALTER TABLE DROP COLUMN
Date: 2003-03-05 18:03:02
Message-ID: 1046887382.3032.127.camel@thor.valhalla.
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi All
I with 7.3.2 I used
ALTER TABLE job DROP x
To drop column x
The result is that column x is now a replaced by a column called
"........pg.dropped.4........."
exists in its place, and now my odbc connections won't touch the table.
I also can't seem to drop or rename this column. I could rename the
table, and do create table as, but I'd like to know if there is
something else I can do use drop column effectively.

Glenn

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Kevin Coyner 2003-03-05 19:09:03 drop table if exists
Previous Message glenn 2003-03-05 17:42:42 Re: SETOF