Blog Category Postgresql
Documenting a PostgreSQL Database
Learn how to document a PostgreSQL database using the COMMENT ON command, catalog queries, psql output, and visual ER diagrams to keep your schema clear.
Postgresql • 31-Aug-2026
A Visual Query Builder for PostgreSQL
How DbSchema builds PostgreSQL SELECTs and joins from the diagram, where the recursive CTE actually goes, and what it will not do to production.
Postgresql • 31-Aug-2026
PostgreSQL Schema Migration: Deploying Changes Safely
Learn how backend developers can safely manage PostgreSQL schema migrations using lock timeouts, the expand-and-contract pattern, and visual schema sync.
Postgresql • 30-Aug-2026
PostgreSQL Transactions Guide with COMMIT and ROLLBACK | DbSchema
BEGIN, COMMIT, ROLLBACK, SAVEPOINT and ROLLBACK TO in one reference, plus isolation levels and the commands PostgreSQL will not run in a transaction.
Postgresql • 29-Aug-2026
How to Document PostgreSQL Databases Effectively | DbSchema
Learn how to document PostgreSQL databases using psql comments and DbSchema visual documentation workflows for teams.
Postgresql • 28-Aug-2026
How to Document a Postgres Database
Document a Postgres database with SQL COMMENT statements applied via psql -f, then export the comments and diagram as one interactive HTML5 file with DbSchema.
Postgresql • 24-Aug-2026
PostgreSQL Database Design Tools: Visual Comparison
DbSchema, pgModeler, SqlDBM, dbdiagram.io and ChartDB compared as PostgreSQL design tools: reverse-engineering, offline modelling and current pricing.
Postgresql • 16-Aug-2026
PostgreSQL Schema Version Control: Methods and Tools
Discover how to manage PostgreSQL schema version control using Git workflows. Learn to diff XML models and generate automated migration scripts safely.
Postgresql • 14-Aug-2026
Best PostgreSQL Database Tools in 2026: 6 GUIs Compared
DbSchema, pgAdmin, Navicat, DbVisualizer, DBeaver and dbForge compared on engines, free tier, price and team features. Prices checked August 2026.
Postgresql • 13-Aug-2026
Top Free PostgreSQL ER Diagram Tools (2026): Compared | DbSchema
Compare top free PostgreSQL ER diagram tools for 2026 with reverse engineering, documentation, and collaboration features to choose the right fit.
Postgresql • 10-Aug-2026
ER Postgres Design with DbSchema – Visual PostgreSQL Schema Workflow | DbSchema
Design PostgreSQL schemas visually with DbSchema. Build ER diagrams, edit tables, sync changes, version schema files with Git, and publish docs.
Postgresql • 15-Apr-2026
How to Handle Large PostgreSQL Schemas with a GUI Tool
Learn how to manage large PostgreSQL schemas with a visual database tool: split diagrams, compare changes, document tables, and handle 10,000+ tables.
Postgresql • 09-Feb-2026
Improve Performance with Range Partitioning in PostgreSQL
Discover how PostgreSQL range partitioning splits large tables into smaller parts based on values like dates or numbers, making queries faster and maintenance easier.
Postgresql • 08-Sep-2025
How to Design a PostgreSQL Schema Visually (Step-by-Step)
PostgreSQL schema design tutorial. Learn visual database modeling with ER diagrams, create tables, set foreign keys, and generate documentation with a GUI tool.
Postgresql • 12-Aug-2025
Create ER Diagrams for PostgreSQL with a Free Design Tool
Design and manage PostgreSQL schemas with a visual ERD tool. Track table relationships, export diagrams, and sync your schema model with Git.
Postgresql • 08-Jul-2025
PostgreSQL JSONB – Operators, GIN Indexes, and Query Examples | DbSchema
Learn PostgreSQL JSONB operators, GIN indexes, path queries, and update patterns. Explore and document JSONB structures visually in DbSchema.
Postgresql • 07-Jul-2025
How to Document a PostgreSQL Schema in 2025
Learn how to create diagrams, add comments, track changes, and export HTML5 docs to fully document your PostgreSQL schema using DbSchema in 2025.
Postgresql • 16-Jun-2025
Improve Your PostgreSQL Database Design and Management with DbSchema
In this article, we will guide you through connecting DbSchema to PostgreSQL database and highlight key features that can enhance your experience with PostgreSQL.
Postgresql • 27-Nov-2024
PostgreSQL Foreign Key – ALTER TABLE, CASCADE Rules, and Indexing | DbSchema
Learn PostgreSQL foreign key syntax, ALTER TABLE, NOT VALID, CASCADE rules, and indexing. Model and document table relationships in DbSchema.
Postgresql • 02-Jun-2023
PostgreSQL JOINs Explained with Examples | DbSchema
Learn how to use PostgreSQL JOIN types with practical examples in psql and DbSchema, including INNER, LEFT, RIGHT, FULL, CROSS, NATURAL, and SELF JOIN.
Postgresql • 30-May-2023
PostgreSQL Aggregate Functions Guide with Examples | DbSchema
Learn how to use PostgreSQL aggregate functions like AVG, COUNT, MIN, MAX, and SUM in psql and DbSchema with practical examples.
Postgresql • 30-May-2023
PostgreSQL CREATE TRIGGER Guide with psql and DbSchema | DbSchema
Learn how to create triggers in PostgreSQL using psql and DbSchema, with trigger types, parameters, examples, and practical guidance.
Postgresql • 29-May-2023
PostgreSQL CREATE PROCEDURE – IN/OUT Parameters, CALL, Transactions, and Errors | DbSchema
Learn PostgreSQL CREATE PROCEDURE with IN/OUT parameters, CALL syntax, transactions, and EXCEPTION handling. Compare procedures vs functions in DbSchema.
Postgresql • 16-May-2023
PostgreSQL CREATE INDEX Guide with psql and DbSchema | DbSchema
Learn how to create indexes in PostgreSQL using psql and DbSchema, including index options, limitations, and practical examples.
Postgresql • 16-May-2023
Drop Table in PostgreSQL – Syntax, IF EXISTS, CASCADE, and Safety Tips | DbSchema
Use DROP TABLE in PostgreSQL with IF EXISTS, CASCADE, and multi-table examples. Review dependencies first and manage changes visually in DbSchema.
Postgresql • 12-May-2023
Create Table in PostgreSQL – Syntax, Data Types, Constraints, and Examples | DbSchema
Create tables in PostgreSQL with practical syntax, data types, keys, defaults, and IF NOT EXISTS examples. Design and sync tables with DbSchema.
Postgresql • 12-May-2023
PostgreSQL CREATE DATABASE Guide with psql and DbSchema | DbSchema
Learn how to create a PostgreSQL database using psql and DbSchema, with setup steps, command examples, and verification tips.
Postgresql • 11-May-2023
PostgreSQL List All Schemas – psql, information_schema, pg_namespace, and search_path | DbSchema
List PostgreSQL schemas with psql, information_schema, and pg_namespace. Filter system schemas, inspect search_path, and browse them in DbSchema.
Postgresql • 27-Apr-2020
Essential PostgreSQL Commands Reference | DbSchema
A practical reference of essential PostgreSQL commands for connecting, listing objects, inspecting metadata, and managing sessions.
Postgresql • 14-Apr-2020
Show Tables in PostgreSQL – psql, SQL Queries, and Schema Filters | DbSchema
Show tables in PostgreSQL with \dt, \dt+, and SQL queries against information_schema or pg_catalog. Filter by schema, include sizes, and list all objects.
Postgresql • 14-Apr-2020
How to Generate Random Data in PostgreSQL | DbSchema
Learn how to generate realistic random data for PostgreSQL tables using DbSchema Data Generator patterns, seeds, and preview tools.
Postgresql • 16-Apr-2019
Describe Table in PostgreSQL – psql, SQL Metadata, and Examples | DbSchema
Describe a PostgreSQL table with psql and SQL metadata queries. See columns, defaults, constraints, indexes, and inspect structure in DbSchema.
Postgresql • 15-Apr-2019
Drop All Tables in PostgreSQL – Safe Methods, CASCADE, and TRUNCATE | DbSchema
Learn how to drop all tables in PostgreSQL safely. Compare DROP SCHEMA, generated DROP TABLE scripts, TRUNCATE, and DbSchema workflows.
Postgresql • 14-Apr-2019
How to Copy a PostgreSQL Database Safely | DbSchema
Learn how to copy a PostgreSQL database using SQL and command-line tools, including connection cleanup and template-based cloning.
Postgresql • 13-Apr-2019