Hello,
I'd like to ask, if anyone has written a tool, allowing to
dump the tables (both the schema and the data), basing on the
'base' table_name, specified by the user. The tables that the database
consists of, form a tree (as a result of the relations), so what I'm
looking for is a program (script), issuing the 'DROP *', 'CREATE *', 'COPY
FROM ' commands in the proper order. pg-dump dumps the whole 'tree' - I'd
like to be able to specify myself the 'root' of this 'tree'.
I realize, that my influency in English makes the description more vague,
than it should be :) sorry.
regards, mark
PS. The reason why I feel I'm in need of suach a thing is that in general,
when I try do pg_dump the database I'm working with, I get the errors -
sometimes the inherited constraints seem to be unappropriate (both in
terms of definitions and with their names), the COPY FROM clause sometimes
also (starting with a particular row) generates error. Analyzing this
would be much more simple, if I focus on the 'subset' of the whole dump -
200+ tables for me is just too big bunch of info.
The other reason is, that all the tables form (logically) several parts -
I keep them together, because the parts interact (joins occur) between one
another. And I'd like to be able to dump a specific logical part.