Convert Column Type in PostgreSQL

 Convert a column to your desired type using the command. Suppose a numeric type column needs to convert to varchar so here it goes.

alter table project_deal
alter column company_id type VARCHAR(255)

In this code, project_deal is a table and company_id is a numeric column so we convert it to varchar, and the character limit is set to 255.

This is how I convert numeric column to varchar type in postgreSQL.