https://wiki.bressey.me/ 2026-05-15T06:56:29+00:00 https://wiki.bressey.me/ https://wiki.bressey.me/lib/tpl/readthedokus/images/favicon.ico text/html 2025-10-22T08:21:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bressey.me/database:postgres?rev=1761121316&do=diff Drop database & close connections drop database [db] WITH (force) Drop all tables DO $$ DECLARE r RECORD; BEGIN FOR r IN (SELECT tablename FROM pg_tables WHERE schemaname = 'public') LOOP EXECUTE 'DROP TABLE IF EXISTS ' || quote_ident(r.tablename) || ' CASCADE'; END LOOP; END $$; text/html 2024-03-14T16:43:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bressey.me/database:sqlite?rev=1710434586&do=diff Check DB integrity sqlite3 ./dev.db PRAGMA integrity_check; Export/Import Export: sqlite3 ./dev.db .output ./backup_users.sql .dump users .exit Import: sqlite3 ./dev.db .read ./backup_users.sql .exit