On 2005-05-10, Peter Eisentraut <[EMAIL PROTECTED]> wrote: > Am Freitag, 6. Mai 2005 12:20 schrieb Andreas Pflug: >> > and the information_schema is next to useless for these things since >> > it doesn't have PostgreSQL specific things in it. >> >> And the restriction to current user owned objects reduces usability to >> zero. > > The information schema restricts the views to the objects to which you have > some access right, which doesn't seem all that useless.
Actually that varies according to the individual view. Some restrict to objects to which you have access, others restrict to objects that you own. Furthermore, in the latter case there is no exception for superusers. -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
