Thread: PL/PGSQL EDITOR
Do exists a PL/PGSQL editor? Thanks.
You can try Crimson Editor, a free powerful editor. http://www.crimsoneditor.com/ Regards Frankie "Eduardo" <epalo@ono.com> wrote in message news:b2h2b0$uqd$1@news.hub.org... > Do exists a PL/PGSQL editor? > > Thanks. > > >
Eduardo, > Do exists a PL/PGSQL editor? Not that I know of. We've talked about this for PGAccess, but nothing's come of it because nobody has the motivation to code it, yet. PGAccess does have a function editor, but it's rather limited. I've been told that TOra (http://www.globecom.se/tora/) functions as a PL/pgSQL editor if you have the Oracle PL/SQL libraries installed. I haven't tried this, myself. I use KDE's Kate. Good luck! -- Josh Berkus Aglio Database Solutions San Francisco
Eduardo wrote: > Do exists a PL/PGSQL editor? > > Thanks. I use VIM with coloured syntax ;-) I had only to make little changes in syntax configuration, because vim thinks whole function is a big comment. Regards, Tomasz Myrta
I use Editplus (http://www.editplus.com/) with PosgreSQL syntax highlighting (ftp://ftp.editplus.com/files/postgre.zip). I also define psql as external tool in Editplus and use shortcut (Ctrl + 1) to send file to server. Tambet ----- Original Message ----- From: "Eduardo" <epalo@ono.com> To: <pgsql-sql@postgresql.org> Sent: Thursday, February 13, 2003 11:20 PM Subject: [SQL] PL/PGSQL EDITOR > Do exists a PL/PGSQL editor? > > Thanks. > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
On Thursday 13 February 2003 22:20, Eduardo wrote: > Do exists a PL/PGSQL editor? Emacs, XEmacs, NEdit. HTH Johannes Lochmann -- Disclaimer - These opiini^H^H damn! ^H^H ^Q ^[ .. :w :q :wq :wq! ^d X^? exit X Q ^C ^c ^? :quitbye CtrlAltDel ~~q :~q logout save/quit :!QUIT ^[zz ^[ZZZZZZ ^H man vi ^@ ^L ^[c ^# ^E ^X ^I ^T ? help helpquit ^D ^d man help ^C exit ?Quit ?q CtrlShftDel "Hey, what does this button d..."
And... for Linux....?
Eduardo, > And... for Linux....? Well, Shane Wright just wrote an PostgreSQL syntax highlighter for Kate (part of the KDE project) Unfortunately, it's part of KDE 3.1, so if you're using a packaged distribution you'll have to wait for the next distribution version. NEdit has a PostgreSQL syntax highlighting overlay that's already available as a downloadable plugin. I'm not fond of NEdit myself because of the lack of multiple windowing, but it's available for 3 platforms and has been in use as long as Xemacs. Speaking of Xemacs, I'd be really surprised if there isn't an Xemacs symtax-checker for PostgreSQL-SQL. Google it. -- -Josh BerkusAglio Database SolutionsSan Francisco
I really like Nedit, because it is much eisier to use than any kind of emacs. I save my sql queries with a .sql extention and Nedit uses a generic SQL syntax highlighting by default. Nedit has many "easy to use" high powered editing features as well and uses standard "CTRL-F,CTRL-C,CTRL-V..." key sequences. I will look for the PostgreSQL specific plugin, but the standard SQL works OK. Guy Josh Berkus wrote: > Eduardo, > > >>And... for Linux....? > > > Well, Shane Wright just wrote an PostgreSQL syntax highlighter for Kate (part > of the KDE project) Unfortunately, it's part of KDE 3.1, so if you're using a > packaged distribution you'll have to wait for the next distribution version. > > NEdit has a PostgreSQL syntax highlighting overlay that's already available as > a downloadable plugin. I'm not fond of NEdit myself because of the lack of > multiple windowing, but it's available for 3 platforms and has been in use as > long as Xemacs. > > Speaking of Xemacs, I'd be really surprised if there isn't an Xemacs > symtax-checker for PostgreSQL-SQL. Google it. >
Folks, > > Well, Shane Wright just wrote an PostgreSQL syntax highlighter for Kate (part > > of the KDE project) Unfortunately, it's part of KDE 3.1, so if you're using a > > packaged distribution you'll have to wait for the next distribution version. Actually, Shane just sent me the XML file, and I got it to work with KDE 3.0.3. If anyone can think of an appropriate place in the suite of PostgreSQL sites, I'll post a copy of it there. -- -Josh BerkusAglio Database SolutionsSan Francisco
Folks, One more note on the PostgreSQL SQL highlighting mode for Kate: Shane Wright, the author, has asked for feedback. So if you use it, please send feedback and requests to me and I'll forward them. -- -Josh BerkusAglio Database SolutionsSan Francisco