Schema and Namespace Oid confusion

From: ZongtianHou <zongtianhou(at)icloud(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Schema and Namespace Oid confusion
Date: 2018-12-28 12:44:27
Message-ID: 860D4620-5D8C-4D24-991B-6B18F2BC94A5@icloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi, everyone

I get somehow confused when I learn about namespace here, there are two questions,
First, what is the difference between namespace and schema?
Second, why the Oid of public namespace is 2200, the same between databases? Does oid is unique for every object across cluster?

Does someone know about these clearly?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2018-12-28 15:26:14 Re: crash during autovacuum
Previous Message Shreeyansh Dba 2018-12-28 11:07:16 Re: crash during autovacuum