Re: [SQL-Ledger-users] Drop Column?

[Pati D. <pa...@se...>]

Well Tom,

Answer ain't there..but..did find:

SELECT (..All columns except the one that you drop...)
INTO TABLE  tmp_name
FROM old_table;
DROP TABLE old_table;
ALTER TABLE  tmp_table RENAME TO old_table;

This will do the trick..!!



----- Original Message ----- 
From: Thomas Sawyer <ps...@on...>
To: <sql...@li...>
Sent: Thursday, February 15, 2001 5:19 PM
Subject: Re: [SQL-Ledger-users] Drop Column?


| As the postgres user, run "psql". At the psql prompt type \h to see help.
| type \h {command_name} to get more specific help.
| 
| -- 
| Thomas Sawyer
| ps...@on... - email
| (303) 285-3487 x1594 - voicemail/fax
| 
| 
| 
| ---- Hal Davison <ha...@fa...> wrote:
| > 
| > If there is a column that one creates by mistake, what is the PostgeSQL
| > function/command that is used to DROP the COLUNM?
| > 
| > 
| > --Hal. 
| > ===========================================================
| > Hal Davison      Internet Petroleum  Gateway
| > Davison Consulting        Caldera 2.2.14  eServer
| > 6850 Myakka Valley Tr    PostgreSQL 7.03 - Sun Forte - JAVA
| > Sarasota, Florida 34241         Phone: (941) 921-6578
| > http://faams.net          eFAX: (419) 821-5999
| > ===========================================================
| > 
| > 
| 
| __________________________________________________
| FREE voicemail, email, and fax...all in one place.
| Sign Up Now! http://www.onebox.com
|