How to use array_to_string in PostgreSQL to change column data type?

Question

I am trying to figure out how to use array_to_string in PostgreSQL to change a column's data type. Currently my column has arrays, for example: ["7856", "2345"]. Which I would like to change to a string: 7856, 2345.

Currently I can just do this with SELECT but can't figure out how to alter the data. So far I have just been using:

SELECT array_to_string(myColumnn,',') as myColumn from myTable

Is there a way to use this to permanently change the data type in the column?

Thank you

Storing delimited values in a column is a bad design decision to begin with. But if you really want to de-normalize your data, then at least stick with proper arrays rather than the dreaded comma separated values. — user330315
– user330315, Commented Dec 6, 2022 at 21:30

Albina · Accepted Answer · 2022-12-06 20:13:25Z

0

ALTER TABLE myTable
ALTER COLUMN myColumn TYPE VARCHAR 
USING array_to_string(myColumnn, ',');

Documentation

answered Dec 6, 2022 at 20:13

Albina

2,0213 gold badges9 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use array_to_string in PostgreSQL to change column data type?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related