Re: sh - script: how to control the output.

[Johann Spies <johann.spies@gmail.com>]

[-- Attachment #1: Type: text/plain, Size: 998 bytes --]

>
> You could try out some of the options for the ":results" header
> argument, as described here:
>
> http://orgmode.org/manual/results.html#results
>
>
>
Thanks Myles.  After a bit of experimenting I got this to work (I have to
remove the *example*  lines to make a table of the output.  But that is OK.


#+BEGIN_SRC sh :results verbatim
#!/bin/sh
echo "\d wos.za_wos_subject_percent_v" | psql -h localhost -p 63334
book_citation | sed '1,2d' | \
sed '/[|+]/s/^/|/'| sed -e '/[|+]/s/$/|/'

#+END_SRC

#+results:
#+begin_example
 View "wos.za_wos_subject_percent_v"
|    Column     |  Type   | Modifiers |
|---------------+---------+-----------|
| id            | integer | |
| subject       | citext  | |
| pubyear       | integer | |
| sa_papers     | numeric | |
| world_papers  | bigint  | |
| za_percentage | real    | |
| rest          | real    | |

#+end_example

Regards
Johann

-- 
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)

[-- Attachment #2: Type: text/html, Size: 1789 bytes --]