title: How to Find all address name from osm that's imported into postgres
body: <p>How can I get all address name from osm. in the schemas imported into postgres database. I have found. But none of them seem to contain a readily available address, which I can easily select. What can I do?</p>
  
  <pre><code> public | geometry_columns   | table | postgres
   public | planet_osm_line    | table | postgres
   public | planet_osm_nodes   | table | postgres
   public | planet_osm_point   | table | postgres
   public | planet_osm_polygon | table | postgres
   public | planet_osm_rels    | table | postgres
   public | planet_osm_roads   | table | postgres
   public | planet_osm_ways    | table | postgres
   public | spatial_ref_sys    | table | postgres
  </code></pre>