[QUESTION] How to retrieve type info for ROW

Поиск

Список

Период

Сортировка

От	Sergey Nuyanzin
Тема	[QUESTION] How to retrieve type info for ROW
Дата	29 ноября 2021 г. 11:01:21
Msg-id	CAKQOUBjw4naub8E0VksQ1T+f25gC5ZgV2A1V8PhkaNd0DjzOFw@mail.gmail.com обсуждение исходный текст
Список	pgsql-jdbc

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

В списке pgsql-jdbc по дате отправления: