Re: [QUESTION] How to retrieve type info for ROW

Hi Dave

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

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