0

When I count number of tables in my schema manually, it is 220.

When I count number of views in my schema manually, it is 23.

220 + 23 = 243

However, this query:

select count(distinct tablename) from PG_TABLE_DEF where schemaname='myschema'

returns 305.

Why is there a mismatch?

mustaccio
  • 28,207
  • 24
  • 60
  • 76
Nasrudeen
  • 101
  • 1

0 Answers0