> it can be a fully new format - designed for simple copy from terminal. Some > like > > ====== record: 10 ====== > ------------ proname ------------ > left > ------------ prosrc ------------ > $lalalal > ewqrwqerw > ewqrwqerqrewq > $ > ===============
> no, it was proposed for psql
How is this better than "copy (...) to stdout"? E.g.:
$ copy (select * from pg_class limit 1) to stdout; 2619 pg_statistic 11 12016 0 10 2 2619 0 18 402 18 2840 t f p r 31 0 f f f f f t n f0 478 1 {postgres=arwdDxt/postgres} \N \N
You can still copy the necessary parts (using mouse selection) - seems that it achieves the the same goal.
I think copy format can be pretty unclean when the line will be longer with multiline values or with a lot of values. When the length of the line will be longer than the terminal width, then searching the wanted column can be pretty difficult.
When you know, so any value is on separate line or lines, then selection is just primitive, and there is good enough information to find wanted data quickly.
For this case I am working with hypothetical longer records with possible multiline fields - just something that does chaos on the terminal, and you want to select some part of data by mouse from the terminal screen.