Sample PostgreSQL SQL File

Download a free PostgreSQL SQL dump with 3 tables and 1,000 rows (50 KB). Test psql imports, pg_dump compatibility, database migration scripts, and PostgreSQL-specific syntax like SERIAL and TEXT types.

sample-postgresql.sql

55.4 KB

1,000 rows

Download

Verified file details

Filename: sample-postgresql.sql
Exact size: 56,771 bytes
Displayed size: 55.4 KB
MIME type: application/sql
Rows: 1,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-postgresql.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

Other SQL files

sample-mysql.sql

55.2 KB

1,000 rows

Download

Verified file details

Filename: sample-mysql.sql
Exact size: 56,547 bytes
Displayed size: 55.2 KB
MIME type: application/sql
Rows: 1,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-mysql.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-sqlite.sql

55.2 KB

1,000 rows

Download

Verified file details

Filename: sample-sqlite.sql
Exact size: 56,555 bytes
Displayed size: 55.2 KB
MIME type: application/sql
Rows: 1,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-sqlite.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-users-table.sql

27.7 KB

500 rows

Download

Verified file details

Filename: sample-users-table.sql
Exact size: 28,413 bytes
Displayed size: 27.7 KB
MIME type: application/sql
Rows: 500
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-users-table.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-ecommerce.sql

245 KB

5,000 rows

Download

Verified file details

Filename: sample-ecommerce.sql
Exact size: 251,375 bytes
Displayed size: 245 KB
MIME type: application/sql
Rows: 5,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-ecommerce.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-blog.sql

228 KB

2,000 rows

Download

Verified file details

Filename: sample-blog.sql
Exact size: 233,200 bytes
Displayed size: 228 KB
MIME type: application/sql
Rows: 2,000
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-blog.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

sample-schema-only.sql

528 B

Download

Verified file details

Filename: sample-schema-only.sql
Exact size: 528 bytes
Displayed size: 528 B
MIME type: application/sql
License: CC0 / Public Domain
Download URL: https://cdn.truefilesize.com/sql/sample-schema-only.sql

See how TrueFileSize generates and measures sample files, or review the editorial policy.

Frequently Asked Questions

How do I import this SQL file into PostgreSQL?

CLI: psql -U postgres -d database_name -f sample-postgresql.sql. Or use pgAdmin's query tool, DBeaver, or any PostgreSQL client. The file uses standard PostgreSQL syntax.

What PostgreSQL-specific features does this file use?

PostgreSQL-specific features include: SERIAL for auto-increment, double-quote identifiers, TEXT type, TIMESTAMP WITH TIME ZONE, and PostgreSQL-style CREATE TABLE syntax.