How to create a Postgres IDE in Emacs

Question

I noticed that emacs has sql-postgres mode. This is a good start, but my needs are very different. I usually have a large SQL file that I edit, and I want to "run" it in the database. I would like to change my code in Emacs, not PG Admin. However, I am a little more picky about how I see the results. I would rather not see the new Emacs buffer, since Emacs is actually not handling grids. I was thinking about releasing some program that could show me the results in a very beautiful interactive presentation. Maybe something like openoffice or some kind of custom piece of code.

I think the best way is to hack the makefile, which will automatically run the sql file against postgres (which may even allow me to switch to any errors). Then, if the script is successful, it is possible to pass the results to some program. But what program and how can I get these results?

Please let me know if there is a better way. I do not want commercial software or free Windows software. I would prefer OpenSource. Any tips?

Answer 1

You can use psql on the command line and install emacs as your editor. Whenever you type \e in psql, it will open your editor. Display grid + emacs and no need to write code.