Export data with inserts statements

Question

Export data with inserts statements

ash67 opened this issue 3 years ago · 4 comments

ash67 commented 3 years ago

Is it possible to export data with insert statements over COPY?

Answer 1 · 2022-05-22T16:28:57.000Z

Not as written. Why do you prefer inserts?

Answer 2 · 2022-05-22T22:42:37.000Z

@mla thanks for getting back to me! I m using pgmem for unit tests. It does not allow COPY to populate the db.

Answer 3 · 2022-05-23T06:10:17.000Z

k, we'd have to look. The COPY is convenient since we kind of fake it out.. we tell it we're going to create the real table name, but then we dump the data from the sample tables. Not sure how we can do that with inserts easily.

But one hack might be to use pg_sample to generate the sample db. Restore it. And then use pg_dump to dump it as insert statements.

Answer 4 · 2022-05-24T03:41:24.000Z

@mla thanks! The hack has worked for me. It does the job.