Re: [GENERAL] How can I get the list of index(or other objects) which depends on a function

2011-01-06 Thread flying eagle
Thanks Filip RembiaƂkowski, that's exactly what I want. 2011/1/6 Filip RembiaƂkowski > > > 2011/1/5 flying eagle > > I want to get all the dependencies of a table, I know how to get the index >> list using sql, but I don't know how to get the list of objec

[GENERAL] How can I get the list of index(or other objects) which depends on a function

2011-01-05 Thread flying eagle
I want to get all the dependencies of a table, I know how to get the index list using sql, but I don't know how to get the list of objects who using a function, for example: CREATE OR REPLACE FUNCTION reverse_last_64(TEXT) RETURNS TEXT AS $$ SELECT array_to_string( ARRAY ( SELECT substring($1,