Thread

Better dump of foreign key data

PostgreSQL Bugs List <pgsql-bugs@postgresql.org> — 2001-05-09T17:09:08Z

Ivn Baldo (ivan.baldo@pilasnet.com) reports a bug with a severity of 4
The lower the number the more severe it is.

Short Description
Better dump of foreign key data

Long Description
When you dump a database wich has tables that have foreign keys, it dumps a lot of things regarding foreign keys that aren't very much normal-idiot human readable.
It would be nice to have it dump things like "status integer references statuses(cod)" when dumping a table, instead of a lot of "internal-like" things.
I wonder if someday the handling of foreign keys changes, then maybe the dumped data could not be restored easily, and also its nice to have clean data about the schema of a database, etc.
This criteria should be applied to other things like simple indexes, they should be created using the "unique" keyword on the table creation (though this slows down the restore, there should be an option to pretty-dump :) ...).
All in all, this is a suggestion for more cleaner and pretty dumps.

Sample Code


No file was uploaded with this report