All objects of a Particular USER

Started by Ashish Karalkarabout 19 years ago3 messagesgeneral
Jump to latest
#1Ashish Karalkar
ashish_postgre@yahoo.co.in

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

#2Quan Zongliang
quanzongliang@gmail.com
In reply to: Ashish Karalkar (#1)
Re: All objects of a Particular USER

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

#3Alvaro Herrera
alvherre@2ndquadrant.com
In reply to: Quan Zongliang (#2)
Re: All objects of a Particular USER

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.