sql query

[Shlomi Fish]

Hi Jude,

On Mon, 5 May 2014 18:36:33 -0400 (EDT)
Jude DaShiell <jdashiel at shellworld.net> wrote:

> I wrote a query in sql using psql for an interactive environment in 
> console mode.  I can get a couple different kinds of output neither of 
> which would be useful for production level work.  

You should be using the PostgreSQL API for a language like
Python, Perl, Ruby, etc. and write a wrapper around it in that language and
write custom output. See for example:

* https://metacpan.org/pod/DBD::Pg

The psql tool is meant for interactive use by
developers and its output is not very customisable or usable.

Regards,

	Shlomi Fish

-- 
-----------------------------------------------------------------
Shlomi Fish       http://www.shlomifish.org/
My Favourite FOSS - http://www.shlomifish.org/open-source/favourite/

Judaism: God is all the shit, all the non‐shit and all the intermediate
demi‐shits in between.

Please reply to list if it's a mailing list post - http://shlom.in/reply .