ob-sql-mode icon indicating copy to clipboard operation
ob-sql-mode copied to clipboard

Enhancement Request: Result tables as Org Mode Tables

Open ghost opened this issue 3 years ago • 1 comments

As I tried to post-process the output from my ob-sql-mode source blocks, I could never quite make the result table "jump over" to the gnuplot source blocks that followed.

Finally I discovered that the regular org babel sql code actually translates the tables produced by psql into org mode tables, whereas ob-sql-mode doesn't.

My current workaround is to use ob-sql-mode during development of the sql code, and then switch to vanilla babel sql mode when I move on to post-processing. It would be much nicer, though, if ob-sql-mode could be given the same kind of result table transformation as the regular org babel sql mode.

ghost avatar Oct 14 '22 06:10 ghost

Partly covered in ob-sql-session. Partly because it's still missing a line between the header and the body of a result. Also psql can produce formatted ascii table on its own (end of man page, \pset border 2).

flintforge avatar Jun 24 '24 09:06 flintforge