Copy functionality trims leading whitespace

[dmfay]

I noticed this just now trying to copy a long query plan out (with "Copy All", on Linux and osx both) -- all the indentation is gone:

QUERY PLAN
Index Scan using thing_id_pkey on thing __local_0__  (cost=119.95..3500170.93 rows=1 width=320)
Index Cond: (id = 'fa0ed97d-0858-57c8-80f9-31434f76c9bd'::uuid)
Filter: (hashed SubPlan 25)
SubPlan 23
->  Index Scan using stuff_id_pkey on stuff stuff_2  (cost=2927.05..3500042.94 rows=1 width=32)
Index Cond: (id = __local_0__.stuff_id)
"Filter: ((hashed SubPlan 22) AND ....

I looked through export.c briefly but didn't see any obvious culprit.

[okbob]

čt 27. 6. 2024 v 20:54 odesílatel Dian Fay ***@***.***> napsal:

I noticed this just now trying to copy a long query plan out (with "Copy All", on Linux and osx both) -- all the indentation is gone: QUERY PLAN Index Scan using thing_id_pkey on thing __local_0__ (cost=119.95..3500170.93 rows=1 width=320) Index Cond: (id = 'fa0ed97d-0858-57c8-80f9-31434f76c9bd'::uuid) Filter: (hashed SubPlan 25) SubPlan 23 -> Index Scan using stuff_id_pkey on stuff stuff_2 (cost=2927.05..3500042.94 rows=1 width=32) Index Cond: (id = __local_0__.stuff_id) "Filter: ((hashed SubPlan 22) AND .... I looked through export.c briefly but didn't see any obvious culprit.

maybe you use default csv format - it does trimming try to use formatted text format instead, please

…

— Reply to this email directly, view it on GitHub <#244>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAEFO4ZRKEM7KPUNETNH5TLZJRNXJAVCNFSM6AAAAABKAPXWSGVHI2DSMVQWIX3LMV43ASLTON2WKOZSGM3TQOBYGY3DOOA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[dmfay]

that worked, thank you!

[okbob]

čt 27. 6. 2024 v 21:00 odesílatel Dian Fay ***@***.***> napsal:

that worked, thank you!

:-)

…

— Reply to this email directly, view it on GitHub <#244 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAEFO464RKDXQ66BADJ4Y63ZJROOHAVCNFSM6AAAAABKAPXWSGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCOJVGQ3TIMBTG4> . You are receiving this because you commented.Message ID: ***@***.***>