Scott Marlowe wrote:
I use nano or vi for most stuff. Both can do color coding quite nicely for .sql files.
mnavahan wrote:
i [sic] need powerful IDE for it with modernize options (extended editor) rich good ....
Scott Marlowe wrote:
Got me. Maybe eclipse has a nice plugin?
I find both Eclipse and NetBeans to be quite sufficient as SQL editors and admin/edit/query front ends for any database system that has a JDBC driver. They probably aren't quite as useful if you aren't using Java, although both have C/C++ capability. I'm not familiar with other IDEs.
No extra plugins were required with the current versions that I downloaded, namely NetBeans 6.8 or 6.9beta or Eclipse Galileo SR2.
The IDEs have additional advantages besides managing databases and editing SQL and program source code, such as providing quite convenient management consoles for popular Java application servers such as Tomcat or various Java EE products, and handling applications' build and deployment phases.
YMMV. They might represent overkill for some folks. I enjoy the convenience of having everything under one roof.
-- Lew -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
