Sample Header Ad - 728x90

Convert postgres varchar[] to text[] without downtime

2 votes
2 answers
2602 views
As I discovered in researching [this question](https://dba.stackexchange.com/q/293904/112479) , converting a column from varchar(100)[] to text[] requires a table rewrite and rebuilding indexes. Is there a way to manage this conversion without the locking and rewriting through some catalog trickery like that used in [this question](https://stackoverflow.com/q/48693373/754254) ? Particularly interested in version 10 if possible
Asked by Felipe (317 rep)
Jun 8, 2021, 02:39 AM
Last activity: Jun 9, 2021, 03:44 AM