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.
[ Parent
| on HN ]
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).