search

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.42k stars 633 forks source link

Feature request to add refcursor content (RM #6285) #4190

Open dpage opened 3 years ago

dpage commented 3 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/6285 Originally created by Richard Yen at 2021-03-03 20:49:23 UTC.

If a user calls a procedure, they will need to take the extra step to get the recursor name before being able to retrieve the data (see image1)

Users need to copy "" label first to fetch the result, but the number N is different each time, which is inconvenient for users.

It would be nice if pgAdmin4 can support a button to show refcursor result (see image2 and image3)

dpage commented 3 years ago

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/5668 Originally created by Richard Yen at 2021-03-03 20:46:15 UTC.

image.png

Filename: image.png

Description: image1

dpage commented 3 years ago

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/5669 Originally created by Richard Yen at 2021-03-03 20:46:28 UTC.

image_(1).png

Filename: image_(1).png

Description: image2

dpage commented 3 years ago

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/5670 Originally created by Richard Yen at 2021-03-03 20:46:31 UTC.

image_(2).png

Filename: image_(2).png

Description: image3

dpage commented 3 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/6285#note-4 Originally created by Nikhil Mohite at 2021-03-19 11:28:45 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed Ready
dpage commented 2 years ago

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/6533 Originally created by Jaime Soler at 2021-12-16 16:40:48 UTC.

pgadmin4_cursor.png

Filename: pgadmin4_cursor.png

dpage commented 2 years ago

Image migrated from Redmine: https://redmine.postgresql.org/attachments/download/6534 Originally created by Jaime Soler at 2021-12-16 16:40:49 UTC.

sqldeveloper_cursor.png

Filename: sqldeveloper_cursor.png

dpage commented 2 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/6285#note-7 Originally created by Jaime Soler at 2021-12-16 16:41:58 UTC.

Hi,

I would be great to have this feature. Customers that comes from sql developer have asked us for this feature. sqldeveloper accesing to refsyscursor !sqldeveloper_cursor.png! pgadmin4 !pgadmin4_cursor.png!

Redmine ticket header update:

Name Old Value New Value
Attachment added pgadmin4_cursor.png
Attachment added sqldeveloper_cursor.png