On Fri, Sep 02, 2005 at 12:33:00AM +0000, Joÿffffffffffe3o Carvalho wrote: > I want information about the following statistics: > -List lock users > -Show schema owners, it may also so more schema information > -Check if a certain table has a toast table
See "Monitoring Database Activity" and "System Catalogs" in the documentation. Here are links to the documentation for the latest released version of PostgreSQL: http://www.postgresql.org/docs/8.0/static/monitoring.html http://www.postgresql.org/docs/8.0/static/catalogs.html -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend