title: what is the equivalent of all_tables and all_tab_columns in postgresql
body: <p>I am trying to run oracle query  </p>
  
  <pre><code>SELECT OWNER,  
         TABLE_NAME 
  FROM ALL_TABLES;
  
  SELECT COLUMN_NAME, 
         DATA_TYPE, 
         DATA_LENGTH, 
         NULLABLE, 
         COLUMN_ID, 
         DATA_PRECISION, 
         DATA_SCALE 
  FROM ALL_TAB_COLUMNS 
  </code></pre>
  
  <p>in postgresql but it is not able to excute that because PostgreSQL doesn't have ALL_TAB_COLUMNS  and ALL_TABLES</p>
  
  <p>Can any body suggest what is the equivalent query of that</p>