Stephen Frost <sfrost@snowman.net> writes:
> Perhaps we should have a 'multi-file' option with a 'base-file-name'
> parameter which then generates:
> pre-data DDL
> data
> post-data DDL
> psql script to run them in order (\i-style)
Actually, I was thinking that the three-file approach is just
unnecessary complication. What about two files, schema and data,
with the schema file including a \i for the data at the right place?
This could be enabled by a single additional switch
"--data-file=filename", with the schema output still going where it
goes now (ie, -f or stdout).
regards, tom lane