Changing colomn length in egdb

[yockee]

I want to change colomn length for a feature class that is involved in feature service, web map and field map.

If I change the colomn length (increase the width)  via PgAdmin, will it effect everything down the line ?

I am using Postgresql 13 with Arcgis enterprise 11.0

thanks

[RyanUthoff]

After changing the column length, you will need to restart (or potentially republish) your feature service so the field length is updated there. But otherwise, yes, changing the column length in the EGDB will be reflected in everything down the line.

[Asrujit_SenGupta]

No, do not make any changes on the Feature Class schema directly from the database end. The enterprise geodatabase system tables are sensitive, and you can end up corrupting your data.

Also, is the data versioned? 

Check the Alter Field tool.

[HarryPlendl]

I don't believe this would be the way I would do it. I have used Postgresql for about 6 years and anything Esri related I do through the tools. Except adding users and roles. 

Add a new column in the data design of the feature class in ArcGIS Pro with the field length and type of data desired. Calculate the field with the values of the original field and then delete the original field. 

Overwrite the service and this will be reflected in all the client apps. You have to overwrite the service as the owner of the service.