ERROR: syntax error at or near "modify" - in postgres

Question

I executed this SQL statement in Postgres

alter table user modify column 'distinguishedName1' text;

and

alter table user modify column distinguishedName1 text;

• user is the table name
• distinguishedName1 is the column name with integer data type.

I wanted to modify the data type to boolean or text or varchar(256) etc based on user's input. But when I run the query I get the error

ERROR: syntax error at or near "modify"

Not sure what is the problem. Help required on right query.

Answer 1

POSTGRES syntax for altering column type :

ALTER TABLE user ALTER COLUMN distinguishedName1 TYPE text;