From: | "Kevin Duffy" <KD(at)wrinvestments(dot)com> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | where-used function |
Date: | 2008-12-29 17:52:15 |
Message-ID: | DFC309C8A42633419600522FA8C4AE1A5611DE@mail-01.wrcapital.corp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Fernando Hevia | 2008-12-29 18:23:15 | Object create date |
Previous Message | Rodrigo E. De León Plicet | 2008-12-25 21:04:32 | Re: SQL syntax I've been unable to figure out.... |