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....
---------------------------------
Here�s 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.