I have some code from my project that does
unload to file select
and load to file insert ...
Which would allow you to change column names or even table names through
the load process.
It wasn't submitted as a patch as I didn't think it added significant
functionality, but apparently there
Robert Treat <[EMAIL PROTECTED]> writes:
> the problem is that I am restoring the data to a database with different
> column names, which errors out in 7.3 (but didn't under 7.2 since it
> didn't produce column names in the COPY output). I checked the docs and
> it provided no clue as to how to sup
in 7.2 doing a data only dump (pg_dump -a -x db > dump) would give
output like:
UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'status';
COPY "status" FROM stdin;
0 INFO
1 WARNING
2 CRIT
\.
-- Enable triggers
UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg