Learn SQL in your browser
A free SQL tutorial in short lessons on one shop database. Every example runs on real PostgreSQL in your browser, and the page checks your answers.
DbSchema Blog
Database design, migrations, SQL and everyday database work — explained with practical examples.
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.
SQLite JOINs: INNER, LEFT, CROSS, and FULL JOIN Workarounds | DbSchema
Learn SQLite JOIN syntax with INNER, LEFT, CROSS, RIGHT, and FULL JOIN guidance, plus version caveats, performance tips, Python examples, and DbSchema.
Reverse Engineering a SQLite Database
Learn how to reverse-engineer an unfamiliar SQLite database file into an ER diagram, extract its schema, and add the missing virtual foreign keys.