Re: table dependencies - Mailing list pgsql-general
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.fwiw, I once wrote a plpgsql function to assist in generating slony set adds.
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 <GavinFlower@archidevsys.co.nz> wrote:
On 07/09/15 19:44, Raymond O'Donnell wrote:On 06/09/2015 22:59, FarjadFarid(ChkNet) wrote:I think I can do it relatively simply, in a reasonable general fashion.No worries.Would you share it, for the archives?
I found a way.
Ray.
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 (pgsql-general@postgresql.org)
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.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
Attachment
pgsql-general by date: