| 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: | Whole Thread | Raw Message | 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.... |