Mail-Followup-To: pgsql-sql@postgresql.org
To: pgsql-sql@postgresql.org
From: Tim Landscheidt <tim@tim-landscheidt.de>
Subject: Getting a list of a table's attributes that are sortable sorted by
	uniqueness
Date: Fri, 30 Dec 2011 01:07:39 +0000
Organization: <URI:http://www.tim-landscheidt.de/>
Lines: 18
Message-ID: <m3vcoyx3xg.fsf@passepartout.tim-landscheidt.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Mail-Copies-To: never
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux)
Cancel-Lock: sha1:+Khx0pT0u/Q5k2BHq1UUbr3n86w=

Hi,

I frequently use pg_dump to dump databases and compare them
with diff.  To get rid of most "false positives", I'd like
to patch pg_dump to sort the table so that its dumped order
isn't changed more than necessary by insertions & Co.

  So I'm looking for a query that will return a list of a
table's attributes that are sortable (e. g. no XML fields)
and sorted by "uniqueness", i. e. first attributes repre-
senting the primary key, then other unique keys, then the
rest.

  Before I dive into the depths of PostgreSQL's system cata-
logues, has anyone already solved this problem?

TIA,
Tim