title: how to get column size and type through my database in PostgreSQL
body: <p>I've changed column length manually in my previous database.</p>
  
  <p>But after creating new database via HQL it's creating <code>varchar(255)</code> and I need to make it longer.</p>
  
  <p>I need to find which table's column should I change?</p>
  
  <p>I can find it manually but now I have about 200 tables and I need a query to do this. </p>
  
  <p>How can I get the column type and its length in Postgres using a SQL query?</p>