you need to do the create and drop table procedure, plus the recreation of
constraints and indices. check the bottom part of this link (directly from
the reference manual of pg).
http://www.ca.postgresql.org/users-lounge/docs/7.1/reference/sql-altertable.html
On Wed, 18 Jul 2001, Percy wrote:
> how about deleting it from the catalog? will it work? i haven't done
> anything yet, hoping for the best solution to my problem....
>
> thanks =)
> ----- Original Message -----
> From: "eric pareja" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, July 18, 2001 3:06 AM
> Subject: Re: [plug] Re: [ph-linux-newbie] questions on postgresql
>
>
> > On Wed, Jul 18, 2001 at 06:06:51PM +0800, Orlando Andico wrote:
> > > On Wed, 18 Jul 2001, Percy wrote:
> > > ..
> > > > hello all!
> > > >
> > > > how to drop columns in postgresql?
> > >
> > > according to pg expert Mike, hindi pwede. Alam ko hindi rin pwede sa
> > > Oracle. The way to do it is
> > >
> > > CREATE TABLE new_table AS SELECT list_of_columns FROM old_table;
> > > DROP TABLE old_table;
> > > CREATE VIEW old_table AS SELECT * from new_table;
> > >
> > > although pg allows table renaming so you prolly don't need the CREATE
> > > VIEW. oracle needs it though.
> >
> > In PostgreSQL,
> >
> > CREATE TABLE new_table AS SELECT list_of_columns FROM old_table;
> > DROP TABLE old_table;
> > ALTER TABLE new_table RENAME TO old_table;
> >
> >
> > --
> > ___ eric pareja ([EMAIL PROTECTED]) - "We're all crazy. No one wants to admit
> it."
> > \@/ http://gra.ph/~xenos/xenos.pgp | http://plug.linux.org.ph
> [O(///)O]======+
> > v "Even the smallest person can change the course of the future." /
> Clue |
> > [ Chiba City: A Cyberpunk MUSH | http://chibacity.erisian.net ]
> +-------+
> >
> > _
> > Philippine Linux Users Group. Web site and archives at
> http://plug.linux.org.ph
> > To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
> >
> > To subscribe to the Linux Newbies' List: send "subscribe" in the body to
> [EMAIL PROTECTED]
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
> _
> Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
> To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
>
> To subscribe to the Linux Newbies' List: send "subscribe" in the body to
>[EMAIL PROTECTED]
>
--
Mike B.
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
