[SQL] where-used function

2008-12-29 Thread Kevin Duffy
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

Re: [SQL] where-used function

2008-12-29 Thread Tom Lane
Kevin Duffy k...@wrinvestments.com writes: 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