Questions tagged [pg-catalog]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
29 views

Is pg_database a catalog or a table?

I am learning about PostgreSQL and am trying to understand basic concepts like schemas, catalogs and tables. I have been reading PostgreSQL: Up and Running, and to quote the book: Schemas are ... the ...
0
votes
1answer
45 views

What is faster: pg_catalog or information_schema?

I understand the high-level differences between pg_catalog and information_schema. But in many cases, a tool could choose to use any of them. And I'm wondering if there are performance reasons why we ...