Re: sql query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Index of Archives]     [Linux Speakup]     [Fedora]     [Linux Kernel]     [Yosemite News]     [Big List of Linux Books]