Blog Category 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
Top Free PostgreSQL ER Diagram Tools for 2025/2026 – Compared | DbSchema
Compare the best free PostgreSQL ER diagram tools for 2025/2026. See reverse-engineering, docs, and collaboration features before you choose.
Postgresql • 09-Jul-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
DbSchema | How to Implement JOINS in PostgreSQL?
In this article, you are going to learn how to implement JOINS in psql and DbSchema.
Postgresql • 30-May-2023
DbSchema | How to Perform Aggregate Functions in PostgreSQL?
In this article, you are going to learn how to implement aggregate functions in psql and DbSchema.
Postgresql • 30-May-2023
DbSchema | How to Create a Trigger in PostgreSQL?
In this article, you are going to learn how to create a trigger in psql and DbSchema.
Postgresql • 29-May-2023
DbSchema | How to Perform a Transaction in PostgreSQL?
In this article, you are going to learn how to perform a transaction in psql and DbSchema.
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
DbSchema | How to Create an Index in PostgreSQL?
In this article, you are going to learn how to create an index in psql and DbSchema.
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
DbSchema | How to Create a Database in PostgreSQL?
In this article, you are going to learn how to create a PostgreSQL database in psql and DbSchema.
Postgresql • 11-May-2023
DbSchema | How to Document PostgreSQL Databases
Learn how to document your PostgreSQL database with psql or with DbSchemas intuitive interface
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
DbSchema | 10+ Essential PostgreSQL Commands
In this article, we are going to list 20 essential PostgreSQL commands to help you manage your databases easily.
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
DbSchema | How to Generate Random Data in PostgreSQL
In this article, you will learn how to generate meaningful data for PostgreSQL databases in less than 5 minutes.
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
DbSchema | Create a Database Copy in PostgreSQL
In this article, we are going to learn how to copy a database in PostgreSQL.
Postgresql • 13-Apr-2019