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

[Thomas S. <ps...@on...>]

Nice!

That's right, I remember now...Postgresql doesn't have a simple means
for dropping columns. I think you did the only thing you could do. This
transfers your data I take it? Hopefully this will be simplified in future
versions of Postgresql. By the way, what are you working on?

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- "Pati Davison" <pa...@se...> wrote:
> 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
> | 
> 
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com