RE: Deleting a COL

Поиск
Список
Период
Сортировка
От Antonio Lagnada
Тема RE: Deleting a COL
Дата
Msg-id NEBBLGHIMLDEONPJLLHHKEALCAAA.lagnada@tbsoa.com
обсуждение исходный текст
Ответ на Re: Deleting a COL  ("Oliver Elphick" <olly@lfix.co.uk>)
Список pgsql-sql
You're right...I tried executing the drop column command but said that it's
not yet implemented.
When is release 7.0 ready for use?

-----Original Message-----
From: Oliver Elphick [mailto:olly@lfix.co.uk]
Sent: Saturday, April 01, 2000 3:47 PM
To: Antonio Lagnada
Cc: Pgsql-sql
Subject: Re: [SQL] Deleting a COL


"Antonio Lagnada" wrote: > >Does anyone know how to delete a column in PostgreSQL? >I cannot find the SQL command to do
it.

ALTER TABLE DROP COLUMN colname

(but I don't think it's supported before release 7.0)

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver              PGP key from public servers; key
ID32B8FAA1                ========================================    "Therefore, if anyone is in Christ, he is a new
 creation; the old has gone, the new has come."                     II Corinthians 5:17
 




В списке pgsql-sql по дате отправления:

Предыдущее
От: "Antonio Lagnada"
Дата:
Сообщение: oid field
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Deleting a COL