Thread: Deleting a COL
Does anyone know how to delete a column in PostgreSQL? I cannot find the SQL command to do it. --- Antonio W. Lagnada lagnada@tbsoa.com
"Antonio Lagnada" wrote: > >Does anyone know how to delete a column in PostgreSQL? >I cannot find the SQL command to do it. ALTER TABLE DROP COLUMN colname (but I don't think it's supported before release 7.0) -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key ID32B8FAA1 ======================================== "Therefore, if anyone is in Christ, he is a new creation; the old has gone, the new has come." II Corinthians 5:17
You're right...I tried executing the drop column command but said that it's not yet implemented. When is release 7.0 ready for use? -----Original Message----- From: Oliver Elphick [mailto:olly@lfix.co.uk] Sent: Saturday, April 01, 2000 3:47 PM To: Antonio Lagnada Cc: Pgsql-sql Subject: Re: [SQL] Deleting a COL "Antonio Lagnada" wrote: > >Does anyone know how to delete a column in PostgreSQL? >I cannot find the SQL command to do it. ALTER TABLE DROP COLUMN colname (but I don't think it's supported before release 7.0) -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key ID32B8FAA1 ======================================== "Therefore, if anyone is in Christ, he is a new creation; the old has gone, the new has come." II Corinthians 5:17
See Faq item on this DROP COLUMN. [Charset iso-8859-1 unsupported, filtering to ASCII...] > > Does anyone know how to delete a column in PostgreSQL? > I cannot find the SQL command to do it. > > --- > Antonio W. Lagnada > lagnada@tbsoa.com > > > -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
-----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-----
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Sat, 1 Apr 2000, Oliver Elphick wrote: > ALTER TABLE DROP COLUMN colname > (but I don't think it's supported before release 7.0) just a note, if it is supported, it is not documented yet in psql, or man alter_table of pgsql 7.0beta3. ____________________}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 iEYEARECAAYFAjjm4JYACgkQCGPRljI8082BOACfRc2HGUIL+zZ5i2LOFojpB9Bi B2AAn3I4+XXvq6tkKNxN09+8diDRBTg4 =QefK -----END PGP SIGNATURE-----
"John M. Flinchbaugh" wrote: >-----BEGIN PGP SIGNED MESSAGE----- >Hash: SHA1 > >On Sat, 1 Apr 2000, Oliver Elphick wrote:>> ALTER TABLE DROP COLUMN colname >> (but I don't think it's supported before release 7.0) > >just a note, if it is supported, it is not documented yet in psql, or man >alter_table of pgsql 7.0beta3. Sorry, I think I was confusing it with something else. The syntax is supported in the parser, but: junk=# alter table t2 drop column name restrict; ERROR: ALTER TABLE / DROP COLUMN is not implemented -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key ID32B8FAA1 ======================================== "If the Son therefore shall make you free, ye shallbe free indeed." John 8:36
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