如何在 Emacs 中构建 Postgres IDE
我注意到 emacs 有一个 sql-postgres 模式。这是一个好的开始，但我的需求非常不同。我通常有一个正在编辑的大型 SQL 文件，并且想在数据库上“运行”它。我想在 Emacs 中编辑我的代码，而不是 PG Admin。然而，我对如何看待结果有点挑剔。我宁愿看不到新的 Emacs 缓冲区，因为 Emacs 确实不能很好地处理网格。我正在考虑弹出一些程序，可以以非常漂亮的交互式视图向我显示结果。也许像 openoffice 或一些自定义代码。
我认为最好的方法是编写一个 makefile，它将自动针对 postgres 运行 sql 文件（这甚至可能允许我跳转到任何错误）。然后，如果脚本成功，可能将结果通过管道传输到某个程序。但是哪个程序以及如何获得这些结果呢？
如果有更好的方法请告诉我。我不需要一些商业软件或仅限 Windows 的免费软件。我更喜欢开源。有什么建议吗？
I noticed emacs has a sql-postgres mode. It's a good start, but my needs are very different. I usually have a large SQL file that I am editing and I want to "run" it on the database. I would like to edit my code in Emacs, not PG Admin. However, I am a bit more picky on how I see the results. I would rather not see a new Emacs buffer since Emacs doesn't really do grids that well. I was thinking of popping up some program that could show me the results in a very pretty, interactive view. Maybe something like openoffice or some custom piece of code.
I think the best method is to hack together a makefile that will automatically run the sql file against postgres (which may even allow me to jump to any errors). Then, if the script is successful, possible pipe the results to some program. But which program and how can I get those results to it?
Please let me know if there is a better way. I don't want some commercial software or Windows-only freeware. I'd prefer OpenSource. Any advice?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您可以在命令行上使用 psql 并将 emacs 设置为您选择的编辑器。每当您在 psql 中键入
\e时，它都会打开您选择的编辑器。网格显示+emacs，无需编写任何代码。You could use psql on the command line and set emacs to be your editor of choice. Whenever you type
\ein psql, it will open your editor of choice. Grid display + emacs and there's no need to write any code.这个响应来得有点晚，但是我开发了一个基于 Emacs 的浏览/编辑界面 PGmacs，它可以让你查看可用的表并修改 PostgreSQL 数据库中的数据。
https://github.com/emarsden/pgmacs
This response arrives a little late, but there is an Emacs-based browsing/editing interface PGmacs which I developed which lets you view available tables and modify data in a PostgreSQL database.
https://github.com/emarsden/pgmacs