How to alter a column’s data type in a PostgreSQL table?

How to alter a column’s data type in a PostgreSQL table?

Asked on January 9, 2019 in PostgreSQL.
Add Comment


  • 1 Answer(s)

    Refer this document  http://www.postgresql.org/docs/current/interactive/sql-altertable.html

    ALTER TABLE tbl_name ALTER COLUMN col_name TYPE varchar (11);
    
    Answered on January 9, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.