| From: | "John M(dot) Flinchbaugh" <glynis(at)butterfly(dot)hjsoft(dot)com> |
|---|---|
| To: | Antonio Lagnada <lagnada(at)tbsoa(dot)com> |
| Cc: | Pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Deleting a COL |
| Date: | 2000-04-02 05:31:17 |
| Message-ID: | Pine.LNX.4.21.0004020015390.23664-100000@butterfly.hjsoft.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)hjsoft(dot)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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John M. Flinchbaugh | 2000-04-02 05:50:19 | Re: Deleting a COL |
| Previous Message | Bruce Momjian | 2000-04-01 23:12:46 | Re: Deleting a COL |