Thread: All objects of a Particular USER

All objects of a Particular USER

From
Ashish Karalkar
Date:
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

Re: All objects of a Particular USER

From
"Zongliang, Quan"
Date:
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....
>
>
> ---------------------------------
>  Here’s 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


Re: All objects of a Particular USER

From
Alvaro Herrera
Date:
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.