Solved

PostgreSQL - Change the sql statement output format

+2

Hello all,

I use the plugin for postgresql and on the dtailed ouput, i have the message “OK: SQL statement result : 1.”.

I would to change this out in “OK: SQL statement result : Primary.” for example, it will depend of the value.

Thank you in advance,

Hassane

Best answer by vcoum

Hi

You can try with the --change-short-output argument. Add it in the EXTRAOPTIONS service macro

--change-short-output="TOREPLACE~REPLACEDBY~gi"

With your example

--change-short-output="1~Primary~gi"

You can add it multiple times, for each of the values you can get

--change-short-output="1~Primary~gi" --change-short-output="2~Second~gi"

If you have a lot of differents values, it can be hard to maintain but it will works

Hope it helps

+13

Hi

You can try with the --change-short-output argument. Add it in the EXTRAOPTIONS service macro

--change-short-output="TOREPLACE~REPLACEDBY~gi"

With your example

--change-short-output="1~Primary~gi"

You can add it multiple times, for each of the values you can get

--change-short-output="1~Primary~gi" --change-short-output="2~Second~gi"

If you have a lot of differents values, it can be hard to maintain but it will works

Hope it helps

+2

Merely Thank You @vcoum

Sign up