Please note that security bugs or issues should be reported to security@pgadmin.org.

Describe the bug

External DB issue (PostgreSQL): Query History is not visible with the external database.

To Reproduce

Steps to reproduce the behavior:

1. Open the query tool and execute some queries.
2. Now open another query tool and click on the Query History tab, it is not showing previously executed queries in history.
3. it shows No History Found
4. Api call for get query history is present but getting some hex values in response.
5. This is because the query_info column in the query_history table has hex values saved.

Expected behavior

A clear and concise description of what you expected to happen.

Error message

If possible, include the full, unedited text of any error messages displayed.

Screenshots

If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: macOS Monterey 12.6
• Version: V6.19 [snapshot build https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2023-01-25/]
• Mode: Desktop

Additional context

Add any other context about the problem here.