Not able to connect directly access DB using pgAdmin
Today when I tried connecting to the DB directly from pgAdmin, I was facing a peculiar issue - "cannot run SET and SHOW operations inline with other statements." (attached SS for reference).
1. I used the API key as my password and the host is correct because my DB is located in Ireland. 2. I have enabled direct access feature in my account settings. 3. I was able to access DB a couple of days ago, but I am not able to access it today.
Let me know if I am doing anything wrong and request you to fix this issue at the earliest