From mboxrd@z Thu Jan  1 00:00:00 1970
From: Myles English <mylesenglish@gmail.com>
Subject: Re: sh - script: how to control the output.
Date: Mon, 02 Nov 2015 11:02:45 +0000
Message-ID: <877fm0d5pm.fsf@gmail.com>
References: <CAGZ55DTS0FBs77SE2RPBe2aTCc7r=6QqQKXUb1V9hqmCs+dn=w@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:49953)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <mylesenglish@gmail.com>) id 1ZtCsz-0006ih-Fb
	for emacs-orgmode@gnu.org; Mon, 02 Nov 2015 06:02:50 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <mylesenglish@gmail.com>) id 1ZtCsv-0007Sg-Ff
	for emacs-orgmode@gnu.org; Mon, 02 Nov 2015 06:02:49 -0500
Received: from mail-wm0-x22d.google.com ([2a00:1450:400c:c09::22d]:33138)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <mylesenglish@gmail.com>) id 1ZtCsv-0007Sa-8x
	for emacs-orgmode@gnu.org; Mon, 02 Nov 2015 06:02:45 -0500
Received: by wmeg8 with SMTP id g8so55724723wme.0
	for <emacs-orgmode@gnu.org>; Mon, 02 Nov 2015 03:02:44 -0800 (PST)
In-reply-to: <CAGZ55DTS0FBs77SE2RPBe2aTCc7r=6QqQKXUb1V9hqmCs+dn=w@mail.gmail.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Johann Spies <johann.spies@gmail.com>
Cc: emacs-orgmode@gnu.org

Hello Johann,

Johann Spies writes:

> In the normal shell, I can do:
>
>  echo '\d wos.wos_papers_by_subject_mv' | psql -h localhost -p 63334
> book_citation | grep '[+|]'
>
> and get the output:
>
>   Column  |  Type   | Modifiers
> ----------+---------+-----------
>  id       | integer |
>  subject  | citext  |
>  articles | bigint  |
>
> When I try this in org-mode:
>
>
> #+BEGIN_SRC sh
>
> echo '\d wos.wos_papers_by_subject_mv' | psql -h localhost -p 63334
> book_citation | grep '[+|]'
>
>
> #+END_SRC
>
> #+results:
> | Column                           |   |   | Type    |   |   | Modifiers |
> | ----------+---------+----------- |   |   |         |   |   |           |
> | id                               |   |   | integer |   |   |           |
> | subject                          |   |   | citext  |   |   |           |
> | articles                         |   |   | bigint  |   |   |           |
>
> What should I do to get the following in org-mode as a result:

You could try out some of the options for the ":results" header
argument, as described here:

http://orgmode.org/manual/results.html#results

Myles