Tag: sql

All the articles with the tag "sql".

• How to update a column's type (in PostgreSQL)

  Published:Jan 4, 2020 |  at 04:01 PM

  So, you have a table and you need to modify a column's type. The problem arise when the column is filled and the type change is incompatible, for example, from string to integer, so **how we can update the type and recompute the filled values to the new type?**