So that's why all those perl database interfaces in cpan, gdbm mysql and postgresql at best are low level tools. Thanks for the heads up! On Tue, 6 May 2014, Shlomi Fish wrote: > Hi Jude, > > On Mon, 5 May 2014 18:36:33 -0400 (EDT) > Jude DaShiell <jdashiel@xxxxxxxxxxxxxx> 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 . > > _______________________________________________ > Blinux-list mailing list > Blinux-list@xxxxxxxxxx > https://www.redhat.com/mailman/listinfo/blinux-list jude <jdashiel@xxxxxxxxxxxxxx> _______________________________________________ Blinux-list mailing list Blinux-list@xxxxxxxxxx https://www.redhat.com/mailman/listinfo/blinux-list