Message-ID: <gh-pgjdbc-pgjdbc-3504-c2736970018@github.com>
From: "vlsi (@vlsi)" <noreply+vlsi@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Wed, 19 Mar 2025 15:01:01 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3504: Wrong schemas fetched for a given catalog as input
In-Reply-To: <gh-pgjdbc-pgjdbc-3504@github.com>
References: <gh-pgjdbc-pgjdbc-3504@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: vlsi
X-GitHub-Comment-Id: 2736970018
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3504
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3504#issuecomment-2736970018
Content-Type: text/plain; charset=utf-8

> I think the term database means the database that you connected to

The problem is that "database" might mean different things there. For instance, it could be "server process" (==PG cluster), and it could be "PG database" (one of `select * from pg_database`).

As far as I understand, in PostgreSQL `users` (==`schema`) do not belong to `databases` (==`catalog`), and it looks like `getSchemas(String catalog` should ignore `catalog` parameter altogether.


---

> Based on the catalog selected, it's corresponding schema's will be shown

@avinashyn , could you clarify what do you mean by "corresponding" schemas for a catalog in PostgreSQL terms?