Thread: All objects of a Particular USER
Hello , All
I want to see all the dependant object of a particular user,
I know this must be present somewhere in information schema,catlog schema
but realy cant figure out.
can any one suggest?
Thanks in advance
Ashish....
Heres a new way to find what you're looking for - Yahoo! Answers
See here: http://www.postgresql.org/docs/8.2/static/catalog-pg-depend.html Regards. On Thu, 5 Apr 2007 07:41:06 +0100 (BST) Ashish Karalkar <ashish_postgre@yahoo.co.in> wrote: > Hello , All > I want to see all the dependant object of a particular user, > I know this must be present somewhere in information schema,catlog schema > but realy cant figure out. > can any one suggest? > > Thanks in advance > Ashish.... > > > --------------------------------- > Heres a new way to find what you're looking for - Yahoo! Answers ----------------------------------------------- Zongliang Quan quanzongliang@gmail.com,quanzongliang@hotmail.com Admin by http://postgresql.oss.tw http://postgresql-chinese.blogspot.com
Zongliang, Quan escribió: > See here: > > http://www.postgresql.org/docs/8.2/static/catalog-pg-depend.html pg_shdepend is more appropriate in this case. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.