{"repo":"emarsden/pgmacs","free":true,"listed":false,"github":"https://github.com/emarsden/pgmacs","clone":"git clone https://github.com/emarsden/pgmacs.git","description":"Emacs is editing a PostgreSQL database.","language":"Emacs Lisp","stars":221,"topics":["database","editor","emacs","postgresql","gui","tui"],"license":"GPL-3.0","category":"databases-storage","readme_excerpt":"PGmacs -- Emacs editing PostgreSQL databases PGmacs provides an editing interface for the PostgreSQL 🐘 object-relational DBMS from Emacs. It allows you to: - browse the list of tables in the database - browse the contents of a table, row by row, in paginated mode for large tables, and navigate between tables if they are linked by a foreign key - edit the value of a column: type RET on the value you want to modify to edit the value in the minibuffer, or type w to edit the value in a widget-based buffer - insert new rows into the table: type + in a table buffer to insert a row with new values obtained from the minibuffer, or type i to insert a new row with values obtained from a dedicated widget-based buffer. - delete a row: type DEL in a table buffer to delete the row at point - copy/paste rows of a database table (type k to copy, y to paste in a table display buffer) - save the contents of a table in CSV or TSV format, or the contents of a row in JSON format It works both in the terminal (TUI) and in GUI mode . 📖 You may be interested in the user manual. Getting started [!TIP] If you want to get a quick feel for what PGmacs can do before installing it, you can try out our prebuilt Podman/Docker container image which includes a terminal-only build of Emacs and the necessary dependencies. In your Emacs initialization file, include the following to check out the latest version of the code from the git repository, as well as the pg-el dependency: ;; Requires Emacs 29 and git (u","default_branch":null,"files":null,"tree":[],"storefront":"/r/emarsden","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/emarsden/pgmacs/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}