Thanks Melvin. Much appreciate it. 

 

 

From: Melvin Davidson [mailto:[email protected]] 
Sent: 07 September 2015 14:38
To: Gavin Flower
Cc: [email protected]; FarjadFarid(ChkNet); pgsql-general
Subject: Re: [GENERAL] table dependencies

 

All, 
fwiw,  I once wrote a plpgsql function to assist in generating slony set adds.

It grabs all the tables in pg_class and sorts them by foreign key count.

You can pull the main query logic from it and modify to suit your needs.

I've attached for your convenience.

 

 

On Mon, Sep 7, 2015 at 6:27 AM, Gavin Flower <[email protected]> 
wrote:

On 07/09/15 19:44, Raymond O'Donnell wrote:

On 06/09/2015 22:59, FarjadFarid(ChkNet) wrote:

No worries.

I found a way.

Would you share it, for the archives?

Ray.



I think I can do it relatively simply, in a reasonable general fashion.

if it is of real interest let me know, and I'll see if I can find time to try 
and implement  it.


Cheers,
Gavin




-- 
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




-- 

Melvin Davidson
I reserve the right to fantasize.  Whether or not you 
wish to share my fantasy is entirely up to you.   
<http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif> 

Reply via email to