A SQL dump file contains the SQL statements needed to recreate a database: CREATE TABLE for schema, INSERT INTO for rows, optionally indexes, constraints, and triggers. The portable subset (single-quoted strings, ANSI types) runs unmodified on Postgres, MySQL, SQLite, and SQL Server. The output of `pg_dump`, `mysqldump`, and SQLite's `.dump` command — the standard backup/seed format for relational databases.
How to open
Any text editor. To execute: `psql < dump.sql`, `mysql < dump.sql`, `sqlite3 db < dump.sql`. Database GUIs (DBeaver, TablePlus, DataGrip, pgAdmin) all import SQL dump files via their migration wizards.