DbSchema Blog - Postgresql

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 - Best Database Management Tools in 2025

Find the PostgreSQL best management tools in 2025.

Postgresql • 10-Oct-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 Transactions Guide with COMMIT and ROLLBACK | DbSchema

Learn how PostgreSQL transactions work with BEGIN, COMMIT, and ROLLBACK in psql and DbSchema, including benefits and practical workflow.

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

How to Document PostgreSQL Databases Effectively | DbSchema

Learn how to document PostgreSQL databases using psql comments and DbSchema visual documentation workflows for teams.

Postgresql • 14-Jul-2020

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

Blog Category Postgresql