I'm trying to create a dump file that only contains the data in my database. I would like it to create the data with the INSERT command. In reading the manual, (http://www.postgresql.org/docs/9.2/static/app-pgdump.html#PG-DUMP-EXAMPLES) i see that I can use either
It wasn't clear from the manual what the difference is. So I tried both and did a diff on the files. There are differences and I'm wondering why. Can someone tell me what the difference is between these two commands?
Here's the full command I'm running:
pg_dump -a --column-inserts -U postgres testdb > /tmp/test_data_as_inserts2.sql
pg_dump -a --attribute-inserts -U postgres testdb > /tmp/test_data_as_inserts.sql
Any tips would be appreciated. In the meantime, I'm going to dig in and see what's different between these two files... why certain records are included and others not.