ob-sql-mode
ob-sql-mode copied to clipboard
Enhancement Request: Result tables as Org Mode Tables
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.
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).