Question regarding /gx and /g mode

[abhishekgahlot2]

Hi, The repo is great.

I am trying it out. I have couple of questions.

I want to run a big query and pass the output to file as json.

I have tried so far is

ch:clickhouse@10/default=> select * from connect_state; \gx  (format=json) output.txt
ch:clickhouse@10/default=> select * from connect_state; \g  (format=json) output.txt

both seems to be doing the same for me.

Wanted to ask which one will not give output in shell and whichone will just output to shell and also dump the data to output.txt

Thanks