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-