Postgres SQL Dump
A Postgres-flavour SQL dump with a CREATE TABLE and INSERT statements — for testing SQL importers and migrations.
-- Postgres-flavour dump
CREATE TABLE users (
id SERIAL PRIMARY KEY,
name TEXT NOT NULL,
email TEXT UNIQUE,
created_at TIMESTAMPTZ DEFAULT now()
);
INSERT INTO users (name, email) VALUES
('Ada Lovelace', 'ada@example.com'),
('Grace Hopper', 'grace@example.com');
Specifications
- Dialect
- PostgreSQL
- Tables
- 1
- Rows
- 2
- Encoding
- UTF-8
What is a .sql file?
SQL files contain plain-text Structured Query Language statements, typically schema definitions, data inserts, or queries used to build or populate a database. Dialect details vary between engines such as PostgreSQL, MySQL, and SQLite. A dump file often recreates an entire database when executed.
How to use this file
Use an example SQL file to test statement parsing, database restore and migration tooling, and dialect-compatibility of import pipelines.
How to use this file for testing
“Postgres SQL Dump” is a deterministic Novus Examples fixture for SQL import. Postgres- and MySQL-flavour SQL dumps with CREATE TABLE and INSERT statements — for testing SQL importers and migrations.
Documented properties for this file: 2 rows · UTF-8. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such — expect parsers to fail loudly rather than silently accept them.
Data fixtures document their exact quirks — delimiters, encodings, null handling, schema, and row counts — in the spec table. Point your parser or importer at the file and assert it handles the documented edge cases; clean and deliberately-messy siblings make before/after diffs straightforward.
Code examples
psql mydb < dump-postgres.sql # PostgreSQL
mysql -u user -p mydb < dump-postgres.sql # MySQLRelated files
- sqlMySQL SQL DumpA MySQL-flavour SQL dump with backtick-quoted identifiers and engine options — for testing SQL importers.
- sqlSQL Lint Shape — Drop Table CommentTiny SAMPLE SQL shape (drop-table-comment) for static-analysis demos — not live DDL.
- sqlSQL Lint Shape — Implicit Cross JoinTiny SAMPLE SQL shape (implicit-cross-join) for static-analysis demos — not live DDL.
- sqlSQL Lint Shape — Missing Where UpdateTiny SAMPLE SQL shape (missing-where-update) for static-analysis demos — not live DDL.
- sqlSQL Lint Shape — Order By Injection ShapeTiny SAMPLE SQL shape (order-by-injection-shape) for static-analysis demos — not live DDL.
- sqlSQL Lint Shape — Select Star InvalidTiny SAMPLE SQL shape (select-star-invalid) for static-analysis demos — not live DDL.
Generated by generation/data_formats.py. Free for any use, no attribution required — license.