ALTER TABLE DROP COLUMN - Mailing list pgsql-novice

From glenn
Subject ALTER TABLE DROP COLUMN
Date
Msg-id 1046887382.3032.127.camel@thor.valhalla.
Whole thread Raw
Responses Re: ALTER TABLE DROP COLUMN  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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






pgsql-novice by date:

Previous
From: glenn
Date:
Subject: Re: SETOF
Next
From: Kevin Coyner
Date:
Subject: drop table if exists