Message-ID: <gh-pgjdbc-pgjdbc-538-c3156689386@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Tue, 05 Aug 2025 21:20:31 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #538: Why getSchemaName return empty string or exists getBaseSchemaName and getColumnName return getColumnLabel?
In-Reply-To: <gh-pgjdbc-pgjdbc-538@github.com>
References: <gh-pgjdbc-pgjdbc-538@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: davecramer
X-GitHub-Comment-Id: 3156689386
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 538
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/538#issuecomment-3156689386
Content-Type: text/plain; charset=utf-8

> > Seems this is not that difficult.
> 
> If it's that simple, I think it's worth implementing. All of this is nothing compared to the code needed to parse queries and complete the missing metadata for a ResultSet.
Yes, agreed. 
> 
> > One question though. Do we want to return `public` or just leave it empty ?
> 
> What are the cases where we cannot find the schema?

`Select 1 as foo` will not provide a schema