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
Every post tagged postgresql on the DbSchema blog.
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.
How to Document a PostgreSQL Schema
Learn how to create diagrams, add comments, track changes, and export HTML5 docs to fully document your PostgreSQL schema using DbSchema.
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.
How to Document PostgreSQL Databases Effectively | DbSchema
Learn how to document PostgreSQL databases using psql comments and DbSchema visual documentation workflows for teams.
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 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.
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.
How to Design a PostgreSQL Schema Visually (Step-by-Step)
PostgreSQL schema design with ER diagrams: create a schema, add tables and columns, set foreign keys, and generate documentation in DbSchema.
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.
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.
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 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.
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 September 2026.
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.
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.
Essential PostgreSQL Commands Reference | DbSchema
psql commands for PostgreSQL 18: connect and switch databases, list schemas and tables, read privileges, dump and restore, find the session holding a lock.
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.
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.
Documenting a PostgreSQL Database
Document a PostgreSQL database with COMMENT ON, read the text back from pg_description and psql, and export the diagram and data dictionary as one HTML5 file.
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.
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 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.
Improve Your PostgreSQL Database Design and Management with DbSchema
Connect DbSchema to PostgreSQL, reverse-engineer the schema into diagrams, build queries, edit related rows, and export HTML5 documentation.
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.
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.
Reverse Engineering a PostgreSQL Database
Learn how to reverse-engineer an existing PostgreSQL database into an offline ER diagram, extract the pg_catalog schema, and map undeclared relations.
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.
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.
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 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 Database Design Tools: Visual Comparison
DbSchema, pgModeler, SqlDBM, dbdiagram.io and ChartDB compared as PostgreSQL design tools: reverse-engineering, offline modelling and current pricing.
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 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 Schema Migration: Deploying Changes Safely
Deploy PostgreSQL schema changes without blocking traffic: lock_timeout, constant defaults, NOT VALID constraints and CREATE INDEX CONCURRENTLY.
The latest order per customer in PostgreSQL with DISTINCT ON | DbSchema
One row per group in PostgreSQL with DISTINCT ON: the ORDER BY it requires, the tie that picks a random row, and when ROW_NUMBER or LEFT JOIN LATERAL is the better tool.