Jaime, > > The project web site has a lot of info, but here is a quick > > example of what it does: > > thebook=# show statistics * from db history; db | minutes | Questions | Connections | Com_delete ---------+----------------+-----------+-------------+------------ thebook | 10/26/09 09:45 | 1 | 0 | 0 thebook | 10/26/09 09:44 | 8 | 1 | 6 thebook | 10/26/09 09:43 | 0 | 1 | 0
> > seems interesting, the syntax needs a little work but... > > > http://www.ExtSQL.com/postgres_notes.php > > > > We certainly welcome your feedback and thoughts on this. > > There is still some hard work to be done. ÃÂ We have an INFORMATION > > SCHEMA implementation for MySQL 5.x, but not yet for PostgreSQL. > > > > we have an information schema since 7.4 > (http://www.postgresql.org/docs/7.4/static/information-schema.html) If you have time to give us any feedback on syntax/output it is welcome. Regarding INFORMATION SCHEMA, we saw it in 7.4.19 but are really struggling with the implementation. In MySQL 5.0.x, the schema tables are created/populated when asked for as temporary tables. There were some built in routines to create the schema tables when needed. It was fairly easy for us to take data from our structures and fill the tables. My first scan on PosgreSQL gave me the impression the tables have more stability and are updated on an ongoing basis? If you have any pointers to schema table creation that would be great! Best regards! -- John ____________________________________________________________________ John Murtari Software Workshop Inc. jmurt...@thebook.com "software that fits!" (TM) (315) 944-0999 (x-211) http://www.SoftwareWorkshop.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
