Reputation: 115
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!
Upvotes: 2
Views: 3915