vscode-postgres
vscode-postgres copied to clipboard
not able to access temp table after its created
I created a temp table and it ran successfully, but when I try to query from the temp table it throws an error "relation TEMP_TABLE_NAME does not exist"
this would likely be due to the fact the the extension does not keep a persistent connection to the database open.
that was a design decision to allow maintenance on the database that requires connections be disconnected, without have to remember which editor/window is keeping the connection open.
could you suggest a workaround for this if any?