back to notes

Backup data of Postgres table (as insert statement)

pg_dump  --data-only --inserts  --table=public.TABLENAME  -f tablename.sql

The generated SQL script does not create the table but only populate its structure using INSERT SQL statements.