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
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://truefilesize.com/files/sql/sample-postgresql.sql
Other SQL files
sample-mysql.sql
55.2 KB
1,000 rows
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://truefilesize.com/files/sql/sample-mysql.sql
sample-sqlite.sql
55.2 KB
1,000 rows
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://truefilesize.com/files/sql/sample-sqlite.sql
sample-users-table.sql
27.7 KB
500 rows
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://truefilesize.com/files/sql/sample-users-table.sql
sample-ecommerce.sql
245 KB
5,000 rows
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://truefilesize.com/files/sql/sample-ecommerce.sql
sample-blog.sql
228 KB
2,000 rows
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://truefilesize.com/files/sql/sample-blog.sql
sample-schema-only.sql
528 B
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://truefilesize.com/files/sql/sample-schema-only.sql
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.
Other data formats
Similar files in other formats
sample-simple.json
87 B
1 rows
Verified file details
- Filename
- sample-simple.json
- Exact size
- 87 bytes
- Displayed size
- 87 B
- MIME type
- application/json
- Rows
- 1
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/json/sample-simple.json
sample-simple.xml
153 B
Verified file details
- Filename
- sample-simple.xml
- Exact size
- 153 bytes
- Displayed size
- 153 B
- MIME type
- application/xml
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/xml/sample-simple.xml
sample-1kb.yaml
1 KB
30 lines
Verified file details
- Filename
- sample-1kb.yaml
- Exact size
- 1,024 bytes
- Displayed size
- 1 KB
- MIME type
- application/octet-stream
- Lines
- 30
- Note
- simple-config
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/yaml/sample-1kb.yaml
sample-1kb.toml
1 KB
30 lines
Verified file details
- Filename
- sample-1kb.toml
- Exact size
- 1,024 bytes
- Displayed size
- 1 KB
- MIME type
- application/octet-stream
- Lines
- 30
- Note
- simple-config
- License
- CC0 / Public Domain
- Download URL
- https://truefilesize.com/files/toml/sample-1kb.toml