pgclimb icon indicating copy to clipboard operation
pgclimb copied to clipboard

Published 20 hours ago • verified publisher icon lukasmartinelli

[question] order of columns in export

Open machytkafitanalytics opened this issue 9 years ago • 2 comments
trafficstars

Hi, looks like you always export columns in alphabetical order (jsonline format). Would it be possible to preserve order in table or to add some switch into command line? Thanks. Josef

machytkafitanalytics avatar Jul 27 '16 11:07 machytkafitanalytics

Yes, I see the same behaviour and it happens even if my select has an explicit order of columns. Could you please provide a parameter or switch that prevents this in JSON and JSONLINEs?

cbertelli avatar Sep 09 '20 21:09 cbertelli

BTW, if the user wants to reorder columns, she may decide to use an ordered list of columns in the (mandatory) SQL query, no need to force the JSON to a different order. It could be useful to omit null columns (with a parameter) as complained in #18 because JSON already has a structure.

cbertelli avatar Sep 11 '20 06:09 cbertelli