15
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