What is PgDeck?
PgDeck is a desktop PostgreSQL management app for secure connections, schema exploration, advanced data grids, staged editing, SQL execution, structure management, exports, and packaged updates.
FAQ
PgDeck FAQ
Common questions about PgDeck, PostgreSQL workflows, secure connections, staged editing, SQL, structure management, exports, updates, and shortcuts.
SecurityEditingSQLStructureShortcuts
Which databases does PgDeck support?
PgDeck is focused on PostgreSQL. The landing page is written around PostgreSQL search terms so people looking for a Postgres GUI can find it.
Can PgDeck edit table rows?
Yes. PgDeck uses a staged editing workflow: no changes are written until you explicitly commit. Cell edits, new rows, duplicated rows, NULL values, and deleted rows can be staged, reviewed, committed in one transaction, or discarded.
Does PgDeck support SQL?
Yes. PgDeck includes a multi-tab SQL editor with syntax highlighting, independent query text, query results, and execution history per tab. It supports SELECT and non-SELECT statements, including INSERT, UPDATE, DELETE, CREATE, ALTER, and DROP.
How are passwords stored?
Connection passwords are encrypted using the operating system secure keychain through Electron SafeStorage and are not stored as plain text on disk.
Can I export PostgreSQL tables?
Yes. PgDeck can copy cell values, copy selected rows as CSV, copy a row as JSON, export the current page to a CSV file, and generate SQL INSERT statements for selected records.
What filtering and search tools are included?
PgDeck supports type-aware filters for text, numeric values, dates, and booleans. Multiple filters can be combined with AND conditions, and global table search uses PostgreSQL ILIKE matching across visible columns.
Can PgDeck manage database structure?
Yes. PgDeck includes a column inspector and structure tools to add columns, rename columns, change column types with optional USING expressions, and drop columns after reviewing generated SQL previews.
Does PgDeck support connection URL import?
Yes. You can paste a PostgreSQL connection string such as postgres:// and PgDeck will populate connection fields, including SSL settings.
Are destructive operations protected?
Destructive table and structure operations such as truncate, drop table, and drop column are separated as administrative actions and require confirmation or SQL preview review before execution.
Does PgDeck have keyboard shortcuts?
Yes. PgDeck includes shortcuts for filter toggling, table search, closing tabs, editing selected cells, adding rows, duplicating rows, committing staged changes, running queries, and zoom controls.
How do packaged updates work?
Packaged PgDeck builds can support optional updates, mandatory updates based on version rules, background downloads with progress, restart-and-install, and automatic relaunch after installation.
Which operating systems are supported?
The download page is structured for Windows, macOS, and Linux builds.
Still evaluating PgDeck?
Compare the free and paid options, then download the build for your operating system.