Re: table dependencies

Поиск

Список

Период

Сортировка

От	Melvin Davidson
Тема	Re: table dependencies
Дата	7 сентября 2015 г. 16:38:34
Msg-id	CANu8Fiy2LXV7Fjc+9RjiVqJRemq0b-tuvgzHML1BKVYyDCSnHw@mail.gmail.com обсуждение исходный текст
Ответ на	Re: table dependencies (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Ответы	Re: table dependencies
Список	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.

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:
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 (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general