Postgres: Convert varchar to text

Posted by williamjones on Stack Overflow See other posts from Stack Overflow or by williamjones
Published on 2010-05-11T17:42:49Z Indexed on 2010/05/11 17:44 UTC
Read the original article Hit count: 284

Filed under:
|
|

I screwed up and created a column as a varchar(255) where that is no longer sufficient. I've read that varchar has no performance benefits over text on Postgres, and so would like to convert the varchar to a text column in a safe way that preserves the data.

What's the best way for me to do this?

© Stack Overflow or respective owner

Related posts about varchar

Related posts about postgresql