We have newly created few tables and schema(with tables under it). We used to fetch the table+ columns info by querying Information_schema.columns table. But the newly created tables and schema are not showing up while querying Information_schema.columns table. Any idea why?
Also I did some research and found a table - pg_tables, under which the newly created tables are listed. But couldn't get the column info here. Could it be joined with any other child table to fetch the column info?
Thanks!