Re: ALTERING A TABLE

Peter Landis wrote:
>
> Hi-
> I'm a newbie at postgresql and ran into a
> situation on trying to alter an element in a table. I
> have a table called company where a field is called
> address. The address field is set to char() 20 and I
> want to alter the value to have an address field of
> 100. What would be the command to alter the table to
> change this field without affecting the data? If
> anyone could help I would greatly appreciate it.

You can't use ALTER TABLE to change a field's data description. You'll
have to make a new table. Then use SELECT INTO to move your data. Then
DROP TABLE oldtable. Then ALTER TABLE tablename RENAME TO newname.

-Ron-