Skip site navigation (1) Skip section navigation (2)

BUG #5986: pg_dump output is not ordered

From: "Daniel Migowski" <dmigowski(at)ikoffice(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5986: pg_dump output is not ordered
Date: 2011-04-19 12:52:40
Message-ID: 201104191252.p3JCqe2W074774@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5986
Logged by:          Daniel Migowski
Email address:      dmigowski(at)ikoffice(dot)de
PostgreSQL version: 8.3.14
Operating system:   Many
Description:        pg_dump output is not ordered
Details: 

Hi,

I would love to give pg_dump an option to produce ordered output. This would
make it much easier to create dump files that are comparable with a textual
diff tools.

The following orderings are required:

* Dump objects ordered by name. I know this cannot be done with all objects,
but at least remain a reproducable, deterministic order.

Also nice would be:

* Dump data ordered by primary key, or if not available, dump data ordered
by all columns. 

In addition it would be nice to have an option to omit oid comments, because
oids are usually not used in databases.

Thank you very much.

Responses

pgsql-bugs by date

Next:From: Kevin GrittnerDate: 2011-04-19 13:42:27
Subject: Re: BUG #5986: pg_dump output is not ordered
Previous:From: anij ninanDate: 2011-04-19 08:40:47
Subject: help

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group