Sql, Postgresql, Programming, Postgres, Data Science.
coded as a string (a very common issue!) or maybe a decimal number was coded as an integer. The basic pattern for changing a column type is: ALTER TABLE table_name ALTER COLUMN column_name TYPE [new_data_type]; We’ll keep working with our sqlholiday database to show some examples. First, create a