Re: Deleting a COL

Поиск
Список
Период
Сортировка
От John M. Flinchbaugh
Тема Re: Deleting a COL
Дата
Msg-id Pine.LNX.4.21.0004020015390.23664-100000@butterfly.hjsoft.com
обсуждение исходный текст
Ответ на Deleting a COL  ("Antonio Lagnada" <lagnada@tbsoa.com>)
Список pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, 1 Apr 2000, Antonio Lagnada wrote:
> Does anyone know how to delete a column in PostgreSQL?
> I cannot find the SQL command to do it.

i  don't think you can.  you can though create a new table with the
desired fields, select or insert into it from the old table, drop the old
table, then rename the new to the old.

____________________}John Flinchbaugh{______________________
| glynis@hjsoft.com         http://www.hjsoft.com/~glynis/ |
~~Powered by Linux: Reboots are for hardware upgrades only~~
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.0 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iEYEARECAAYFAjjm26AACgkQCGPRljI8080B6ACgkQzO5QKrSOogVK2WDYYiyAdK
nAYAn0xWRca+n+05m0mEVdmGDgsyBWKz
=iIus
-----END PGP SIGNATURE-----




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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Deleting a COL
Следующее
От: "John M. Flinchbaugh"
Дата:
Сообщение: Re: Deleting a COL