where-used function - Mailing list pgsql-sql

From Kevin Duffy
Subject where-used function
Date
Msg-id DFC309C8A42633419600522FA8C4AE1A5611DE@mail-01.wrcapital.corp
Whole thread Raw
Responses Re: where-used function
List pgsql-sql

Hello All:

 

Hope everyone is enjoying a peaceful holiday season.

 

I am using this quite time between the holidays to get my dev and production environment back into sync.

 

It would be very helpful, if I had a where-used function.  This function, given an object name, would determine

if the object exists in the database ( i.e. is it a table or a view)  and then, most important, what other objects are dependant on the object.

 

A database I worked with years ago, distributed by a marketing company in the NorthWest USA, had such a function.

As I remember that function was buggy.

 

Does anybody know if a where-used function exists for the wonderful database known as Postgres?

 

Many Thanks

 

Kevin Duffy

 

pgsql-sql by date:

Previous
From: "Rodrigo E. De León Plicet"
Date:
Subject: Re: SQL syntax I've been unable to figure out....
Next
From: "Fernando Hevia"
Date:
Subject: Object create date