From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | scrappy(at)hub(dot)org (Marc G(dot) Fournier) |
Cc: | olly(at)lfix(dot)co(dot)uk, joey(at)infodrom(dot)north(dot)de, pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] Re: More PostgreSQL stuff |
Date: | 1998-10-04 18:46:09 |
Message-ID: | 199810041846.OAA19549@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On Fri, 2 Oct 1998, Oliver Elphick wrote:
>
> > > . I wonder how one could add or remove columns from existing tables.
> > >
> > > With mSQL this was possible with a trick. You had to dump the
> > > whole table but you could tell the dump program to add dummy fields
> > > or to leave out existing fields. Is there any such possibility
> > > with PostgreSQL?
>
> chk out the 'ALTER TABLE' man page...you can add columns quite
> easily using this. removing coloumsn is a little more tricky at this
> point in time, but we're hoping to add it to the ALTER TABLE syntax 'in
> the future'.
>
> Basically, to drop a column, do an 'INSERT INTO...SELECT FROM' (my
> syntax may be slightly off, please check man pages) from the table you
> want to remove the column from, such that you only insert the columns you
> want to remain. Then, when finished, do a ... damn, haven't used this one
> yet, so don't remember what the 'command' is...but there is one to do a
> RENAME of a table...rename the old to something different, and rename the
> new to the old...
This is an FAQ item.
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 1998-10-04 19:14:09 | Re: [GENERAL] System admin |
Previous Message | Marc G. Fournier | 1998-10-04 18:23:51 | Re: [GENERAL] Re: More PostgreSQL stuff |