News for hackers. Stuff that matters.
Re:Postgres: The Bits You Haven't Found by fusiongyro on Sunday March 03, 2013 @12:20AM (#5312655)
It's worth noting that using some of these features bump you up into a different pricing tier. And last time I checked the usual way to achieve a recursive query was with the non-standard "CONNECT BY" syntax. I have found rlwrap does a lot to mitigate the pain of sqlplus, but I still use it (and Oracle) as little as I can possibly get away with.
Re:Postgres: The Bits You Haven't Found by mercurial on Sunday March 03, 2013 @09:49AM (#5313886)
Even with rlwrap, sqlplus is awful. However, you can try SQL developer, which is fairly decent GUI frontend:

http://www.oracle.com/technetwork/developer-tools/sql-develo...

Re:Postgres: The Bits You Haven't Found by fusiongyro on Monday March 04, 2013 @11:17AM (#5318876)
I actually wind up using both. But SQL Developer is pretty heavy and I prefer using psql to a GUI tool with Postgres, so I wind up in sqlplus a lot (when dealing with Oracle, which is seldom).
Re:Postgres: The Bits You Haven't Found by mickeyp on Sunday March 03, 2013 @10:09AM (#5313958)
Or if you're an Emacs user you can use sqlplus.el, a very nice wrapper around SQL*Plus.