How to alter postgres column data type using hibernate query

Question

The alter column data type syntax in postgresql is :

ALTER TABLE table_name 
ALTER COLUMN column_name 
TYPE newType USING (column_name::newType)

I'm trying to use it via hibernate's SQLQuery to manage some dynamically created tables. The problem is hibernate sees ::newType as being parameters and throws a parameter not found error, and if I don't use casting postgres throws another error asking me to cast the type.

Is there any way of achieving this via hibernate?

have you tried with USING (column_name\\:\\:newType)? I think i have seen sth like this before — Apostolos
– Apostolos, Commented Jul 11, 2016 at 10:06
@Apostolos It works. I tried looking up the hibernate escape character but couldn't find it, I never assumed it would be just the basic java escape. Please post it as an answer so I can accept it. — Alexandru Severin
– Alexandru Severin, Commented Jul 11, 2016 at 14:29

Apostolos · Accepted Answer · 2016-07-11 14:32:51Z

1

Please escape the :: like this

USING (column_name\\:\\:newType)

answered Jul 11, 2016 at 14:32

Apostolos

10.5k5 gold badges32 silver badges44 bronze badges

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

Collectives™ on Stack Overflow

How to alter postgres column data type using hibernate query

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