Re: Deleting a COL

-----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-----