Postgres Pro
Downloads
Home   >   mailing lists

Re: [QUESTION] How to retrieve type info for ROW - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: [QUESTION] How to retrieve type info for ROW
Date
Msg-id CADK3HHJwqVPHW=HvaFEoS5PUprtcEb6KHBqkOa=sCWPnDyc=vQ@mail.gmail.com
Whole thread Raw
In response to [QUESTION] How to retrieve type info for ROW  (Sergey Nuyanzin <snuyanzin@gmail.com>)
List pgsql-jdbc
Tree view
Sergey,

What I suspected it would return. The problem is the backend does not provide us with anything better than unknown OID

Dave Cramer
www.postgres.rocks


On Tue, 7 Dec 2021 at 03:54, Sergey Nuyanzin <snuyanzin@gmail.com> wrote:
Hi Dave

it returns object with field referencing to some unknown oid (screen attached)

image.png


On Mon, Dec 6, 2021 at 1:47 PM Dave Cramer <davecramer@postgres.rocks> wrote:
Hi Sergey,

What does getResultSetMetadata return?


Dave Cramer
www.postgres.rocks


On Mon, 29 Nov 2021 at 07:19, Sergey Nuyanzin <snuyanzin@gmail.com> wrote:
Hi everyone

I'm trying to read data from Postgres with pgjdbc.
The current question is: how can I retrieve data about nested row types?
I tried to find an answer via docs but failed

E.g. there is a query
SELECT ROW(1, 'one', ROW(1, 'one', null, ROW(1)));

I noticed some projects where people take its string representation like
java.sql.ResultSet#getString(int)
parse it and reconstruct the object...
however this way probably could lead to type info losing

I wonder if there is a more subtle way here?

--
Best regards,
Sergey


--
Best regards,
Sergey
Attachment

pgsql-jdbc by date:

Previous
From: Sergey Nuyanzin
Date:
Subject: [QUESTION] How to retrieve type info for ROW
Next
From: Dave Cramer
Date:
Subject: PostgreSQL JDBC and the log4j CVE