Postgres: Convert varchar to text

I screwed and created the column as varchar (255), where this is no longer enough. I read that varchar has no advantages over Postgres text, so I would like to convert varchar to a text column in a safe way that saves the data.

What is the best way for me to do this?

+43
text postgresql varchar
May 11 '10 at
source share
1 answer
ALTER TABLE table1 ALTER COLUMN column1 TYPE text; 
+64
May 11 '10 at 18:07
source share



All Articles