I am trying to change data type from `text` to `varchar` in all of my tables at once.

This query

```
  select *
  from information_schema.columns
  where data_type = 'text'

```

shows me all of my `text` data types, but how do I use this to then alter type to `varchar`.