Re: Increasing Table Column Size in 7.0 Syntax

On Wed, Nov 01, 2000 at 12:43:45PM -0500, J. Atwood wrote:
> Hello,
>
> Looking at the docs for pgsql I have only found stuff on altering a table
> for default and renaming a column but nothing on changing the size. I want
> to increase the size of a field from 2048 to 4096.
Can you tell me, how will do this for example with Oracle? Or Interbase?
Just because I had needed this, I did:
1) create new attribute (ok, column)
2) run "update table1 set n_col=o_col"
3) drop old column (ok, attribute)

--
Igor Roboul, Unix System Administrator & Programmer @ sanatorium "Raduga",
Sochi, Russia
http://www.brainbench.com/transcript.jsp?pid=304744