| From: | Susan Hurst <susan(dot)hurst(at)brookhurstdata(dot)com> |
|---|---|
| To: | Discuss List Postgres <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | TAbles/Columns missing in information schema |
| Date: | 2019-05-10 22:46:05 |
| Message-ID: | ffe9f7c70894eb95e9cb8543277c050d@mail.brookhurstdata.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Why would schemas/tables/columns be missing from
information_schema.tables/information_schema.columns?
We recently promoted some new tables to production but only 2 of the 4
schemas appeared in
information_schema.tables/information_schema.columns.
The schemas/tables/columns do exist as expected but they are not
represented in information_schema.tables/information_schema.columns.
Why is that? Where can I find the missing info for use in a view that
displays the tables and columns in a database?
Thanks for your help!
Sue
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Susan E Hurst
Principal Consultant
Brookhurst Data LLC
Email: susan(dot)hurst(at)brookhurstdata(dot)com
Mobile: 314-486-3261
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2019-05-10 22:51:25 | Re: TAbles/Columns missing in information schema |
| Previous Message | neeraj kumar | 2019-05-10 20:32:54 | Re: Query on pg_stat_activity table got stuck |