PSequel

Small tool for quick sql query, specialized in PostgresSQL. Written in Vala for GNOME desktop in the hope to be useful.

This project is not a part of or affiliated with PostgreSQL.

Features

• Load and save connections.
• Import and Export connections info
• List schema info, tables, views.
• View table columns info, indexes, foreign keys
• View table data, sort by column
• Write query
• Query History
• Hightlight current query
• Export query data

Installation

Flatpak

Recommended

Click here to install app from Flathub.

Build from source

Via GNOME Builder

PSequel can be built with GNOME Builder >= 3.38. Clone this repo and click run button.

(Warning: required to rebuild postgres, will take a little bit of time)

Via Meson

Psequel can be built directly via Meson:

git clone https://github.com/ppvan/psequel
cd psequel
meson build
cd build
meson compile

Next, it can be installed by meson install.

Dependencies

If you use GNOME Builder or Flatpak, dependencies will be installed automatically. If you use pure Meson, dependencies will be:

• vala >= 0.56
• gtk >= 4.10
• gtksourceview >= 5.0
• gio >= 2.74
• json-glib >= 1.6
• libadwaita >= 1.4
• postgres-libs >= 15.3
• libcsv >= 3.0 (built as subproject if missing)
• pgquery-vala

pg_dump -s --no-comments -t "actor" -O -x --dbname "user=postgres password=postgres port=5432 dbname=dvdrental"| grep -v '^$' | grep -v '^(--\s*|SET\s+\w+\s*=).*$'
SELECT pg_catalog.set_config('search_path', '', false);
CREATE TABLE public.actor (
    actor_id integer DEFAULT nextval('public.actor_actor_id_seq'::regclass) NOT NULL,
    first_name character varying(45) NOT NULL,
    last_name character varying(45) NOT NULL,
    last_update timestamp without time zone DEFAULT now() NOT NULL
);
ALTER TABLE ONLY public.actor
    ADD CONSTRAINT actor_pkey PRIMARY KEY (actor_id);
CREATE INDEX idx_actor_last_name ON public.actor USING btree (last_name);
CREATE TRIGGER last_updated BEFORE UPDATE ON public.actor FOR EACH ROW EXECUTE FUNCTION public.last_updated();

Contributions

Contributions are welcome.

Credits

• Psequel - MacOS postgresql client. This project is inspired by Psequel.
• libpg_query - PostgresSQL parser
• libcsv - Robust C csv library