{"id":63,"date":"2011-05-17T01:48:38","date_gmt":"2011-05-17T01:48:38","guid":{"rendered":"http:\/\/blogs.gentoo.org\/titanofold\/?p=63"},"modified":"2011-05-17T01:48:38","modified_gmt":"2011-05-17T01:48:38","slug":"postgresql-syntax-highlighting-in-emacs","status":"publish","type":"post","link":"https:\/\/blogs.gentoo.org\/titanofold\/2011\/05\/17\/postgresql-syntax-highlighting-in-emacs\/","title":{"rendered":"PostgreSQL Syntax Highlighting in Emacs"},"content":{"rendered":"

So, a little while ago I discovered sql-mode and syntax highlighting, plus a little, for PostgreSQL SQL scripts.<\/p>\n

I know, you’re asking, “But, Aaron, how did you not discover this a long time ago?!” Simply put, I usually do everything I need to do in the psql<\/code> shell. I’ve never really needed to write SQL scripts or edit them.<\/p>\n

Then, shadowdaemon was pipping his squeak about having gotten psql-mode working in Emacs. That got me to take a look at what modes are available for PostgreSQL and Emacs. (app-emacs\/psql is now masked as it has been abandoned by upstream a really long time ago, and the package required dev-db\/postgresql-server which was incorrect.)<\/p>\n

So, I just opened an SQL script that came along with rsyslog and Emacs set itself to sql-mode, which is included as a part of the core install. Not quite the proper mode for a PostgreSQL script, but close. There is a product selection, though, so with that one setting I had proper syntax highlighting going and I could connect straight to the database within Emacs. Pretty nifty if I do say so myself, which I do.<\/p>\n

Now for some interesting bits. I’m obviously quite involved with PostgreSQL and I’d want my Emacs to default to PostgreSQL syntax highlighting, so I’ve added the following to my ~\/.emacs<\/code>:<\/p>\n

(eval-after-load \"sql\"\r\n  '(progn\r\n    (sql-set-product 'postgres)\r\n    )\r\n  )<\/pre>\n
This works out pretty nicely as now Emacs defaults to using the proper syntax scheme. I wanted to take this a step further and have psql<\/code> do the right thing also, but I use the server\/client mode with Emacs so I don’t have a ton of windows open at any given time. Also, when emacsclient<\/code> is invoked by psql<\/code>, I want it to set the proper mode, so here comes some trickery.<\/p>\n
In my ~\/.bashrc<\/code> I added:<\/p>\n
PSQL_EDITOR=\"emacsclient --eval \\\"(setq-default major-mode 'sql-mode)\\\"; emacsclient\"<\/pre>\n
When psql<\/code> is given \\e<\/code>, it’ll open a connection to my Emacs server with the sql-mode loaded, and my ~\/.emacs<\/code> sets the product and all is right with the world.<\/p>\n
So, vim<\/em>, what can you do? Seriously. I’d like to resolve an easy bug<\/a> (bugs.gentoo.org) before I die.<\/p>\n","protected":false},"excerpt":{"rendered":"
So, a little while ago I discovered sql-mode and syntax highlighting, plus a little, for PostgreSQL SQL scripts.<\/p>\n","protected":false},"author":136,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[3,4],"tags":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p1tO5a-11","_links":{"self":[{"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/posts\/63"}],"collection":[{"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/users\/136"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/comments?post=63"}],"version-history":[{"count":11,"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/posts\/63\/revisions"}],"predecessor-version":[{"id":92,"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/posts\/63\/revisions\/92"}],"wp:attachment":[{"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/media?parent=63"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/categories?post=63"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/tags?post=63"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}