Skip to content

Conversation

dmfay
Copy link
Contributor

@dmfay dmfay commented Dec 15, 2020

In pgcenter top, multiline queries are collapsed without regard to spacing, so the top query itself is rendered so (no space between SELECT and the first column):

SELECTpid,client_addr AS cl_addr,...

Switching the order of regexp_replaces and adding a space for \n instead of treating it as zero-width yields more readable and copy-pastable SQL:

SELECT pid, client_addr AS cl_addr,...

@lesovsky lesovsky merged commit 3fa7bdf into lesovsky:master Dec 15, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

2 participants