Received: from ns.linux.bogus (IDENT:qmailr@APastourelles-101-1-2-153.abo.wanadoo.fr [193.251.53.153]) by hub.org (8.9.3/8.9.3) with SMTP id JAA43923 for ; Sun, 2 Apr 2000 09:51:38 -0400 (EDT) (envelope-from fabrice.scemama@gesnet.net) Received: (qmail 31246 invoked by uid 531); 3 Apr 2000 16:02:39 -0000 Received: from ns2.linux.bogus (HELO gesnet.net) (gesnet@192.168.0.2) by ns.linux.bogus with SMTP; 3 Apr 2000 16:02:39 -0000 Message-ID: <38E76F7D.30248E46@gesnet.net> Date: Sun, 02 Apr 2000 18:04:13 +0200 From: Fabrice Scemama X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i586) X-Accept-Language: en MIME-Version: 1.0 CC: Pgsql-sql Subject: Re: Deleting a COL References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200004/13 Personnally, i do this: alter table xxx rename bad_col to ___scratchY; where Y is a number. Every day, just before the vacuum is done, a cron will stop the daemon and make the operation being proposed below, if ___scratchYs fields are found. I suspect databases like SQL Server7 to announce delete row possible, but to content themselves with renaming and hiding. "John M. Flinchbaugh" wrote: > > -----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----- -- "Ce n'est pas parce qu'on dit : "Fermez la porte, il fait froid dehors", qu'il fait moins froid dehors quand la porte est fermee." -- Pierre Dac