# Dump a PostgreSQL table as insert statements

DevFeed: [Dump a PostgreSQL table as insert statements](<https://devfeed.tech/articles/dump-a-postgresql-table-as-insert-statements-37704.md>)

Original publisher: [Read original article](<https://carlosbecker.com/posts/dump-postgres-table-inserts/>)

Author: Carlos Alexandro Becker

Published: 2015-02-19T00:00:00Z

Content type: tutorial

Language: en

Sources: [Carlos Becker](<https://devfeed.tech/sources/carlos-becker.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Command-line interface](<https://devfeed.tech/topics/cli.md>)

Tags: [command-line](<https://devfeed.tech/tags/command-line.md>), [dump](<https://devfeed.tech/tags/dump.md>), [insert](<https://devfeed.tech/tags/insert.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

A quick tutorial on dumping a single PostgreSQL table as SQL INSERT statements so its data can be shared for frontend testing without dumping the entire database.

## Source excerpt

FYI: Like the previous post, this is a really quick tip.