I am trying to run oracle query

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 

in postgresql but it is not able to excute that because PostgreSQL doesn't have ALL_TAB_COLUMNS and ALL_TABLES

Can any body suggest what is the equivalent query of that

Edit
Report