From: | martin(dot)chantler(at)convergys(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Modify Column |
Date: | 2000-12-01 16:32:08 |
Message-ID: | 852569A8.005AED03.00@notes.cbis.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I don't know if you can use ALTER TABLE to do this
but you could rename the old column, add a new column with
the right name and size and use an UPDATE statement to
copy the data in.
Unfortunately I had problems dropping the old column since
ALTER TABLE xxx DROP COLUMN zzzz is not implemented in
the version on p-sql I'm using - I wonder if its in a later release???
If not you might have to create a whole new table and copy the data
in with a INSERT INTO xxx SELECT * from zzz;
Hope this helps, maybe someone else knows the ultimate way of doing this :)
MC
joe(at)jwebmedia(dot)com on 01/12/2000 15:23:03
Please respond to joe(at)jwebmedia(dot)com
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
cc: (bcc: Martin Chantler/CIMG/CVG)
Subject: [GENERAL] Modify Column
This seems like a simple enough thing, and I'm sure it's been answered,
but I couldn't find anything that helped in the archives. Basically, I
have a column in my table that was, once upon a time, large enough, but
now, I need to increase the site of the column. How can I do that?
Thanks,
Joe
From | Date | Subject | |
---|---|---|---|
Next Message | joe | 2000-12-01 16:54:38 | Re: Modify Column |
Previous Message | Robert B. Easter | 2000-12-01 16:31:40 | Re: Modify Column |