Write a psql script to list the columns with `text` datatype

 Write a psql script to list the columns with `text` datatype
Answer:

SELECT column_name
FROM information_schema.columns
WHERE table_name = 'myTable'
  AND (data_type = 'text' OR data_type = 'character varying');