Message-ID: <gh-pgjdbc-pgjdbc-538-c3154836595@github.com>
From: "prrvchr (@prrvchr)" <noreply+prrvchr@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Tue, 05 Aug 2025 11:33:49 +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: prrvchr
X-GitHub-Comment-Id: 3154836595
X-GitHub-Comment-Type: issue_comment
X-GitHub-Edited-At: 2025-08-05T11:57:22Z
X-GitHub-Issue: 538
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/538#issuecomment-3154836595
Content-Type: text/plain; charset=utf-8

Well, I have exactly the same problem with the Oracle JDBC driver ojdbc17.jar. Their ResultSets don't provide the table name or schema name in the metadata. Well done, Oracle...

But if I take the trouble to find the table name in the SQL query and make sure it is a `SELECT` query that only looks at one table, then I can find the missing data and make this ResultSet editable in LibreOffice Base.

I'm not going to claim anything from Oracle, that would be a waste of time, and neither here, but I would like to point out that analyzing the query in order to extract the name of the table should be part of the JDBC driver (if it is supposed to be called that).