Re: Deleting a COL - Mailing list pgsql-sql

From John M. Flinchbaugh
Subject Re: Deleting a COL
Date
Msg-id Pine.LNX.4.21.0004020015390.23664-100000@butterfly.hjsoft.com
Whole thread Raw
In response to Deleting a COL  ("Antonio Lagnada" <lagnada@tbsoa.com>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Deleting a COL
Next
From: "John M. Flinchbaugh"
Date:
Subject: Re: Deleting a COL