Postgres Altering column type using user-defined function

Question

I have a column which is stored as TEXT, I would like to change it to UUID in postgres. But I need to run some function on the column first to change it to UUID. Is it possible to do smth like that?

ALTER TABLE am.product ALTER COLUMN p_merchant_id TYPE UUID USING myFunc;

Where myFunc returns UUID with the input merchant_id?

user330315 · Accepted Answer · 2018-11-05 09:54:02Z

2

Yes, that's possible.

You just need to pass the old value to your function:

ALTER TABLE am.product 
   ALTER COLUMN p_merchant_id TYPE UUID USING myfunc(p_merchant_id);

answered Nov 5, 2018 at 9:54

user330315

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

Collectives™ on Stack Overflow

Postgres Altering column type using user-defined function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related