From: Robert Carbonari <robertC@opmr.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] How do I drop a column from a table?
Date: Tue, 31 Aug 1999 10:34:47 -0400
Message-ID: <91E49E736688D21185F500A0C985C705156D9D@DOOM> (raw)
> Hi,
>
> I'm still quite new at this but it should be a simple operation: How do I
> drop a column form a Postgres table. The next best thing would be knowing
> how to change a column so that it can accept null values.
>
> Any takers?
Hi Robert,
I don't know how to email all in elm, so if you could forward this to the
list
for verification I would appreciate.
Anyway, I don't think you can drop a column. What you can do is create a
new table by doing a select into the new table (leaving out the columns you
don't want) and then droping the old table. Once the old table is dropped
you can rename the new to the old one's name:
select f1,f2...,fn into table newtable from oldtable;
drop table oldtable;
alter table newtable rename to oldtable;
Hope this helps...james
> ************
>
Robert Carbonari
Programmer
Optimal Robotics Corp.
e-mail: robertc@optimal-robotics.com
phone: (514)738-8885 ext. 146
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: robertC@opmr.com
Subject: Re: [INTERFACES] How do I drop a column from a table?
In-Reply-To: <91E49E736688D21185F500A0C985C705156D9D@DOOM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox