Re: [ADMIN] system catalog views + tables

2008-10-28 Thread Joshua Drake
On Tue, 28 Oct 2008 13:11:38 -0700 Isabella Ghiurea <[EMAIL PROTECTED]> wrote: > Hello, > How can I see all system catalog tables and views , I'm in potsgres > db ( using PG 8.3). > Is there a way to have /get a full list and description of system > tables and views in kind of hard copy forma

[ADMIN] system catalog views + tables

2008-10-28 Thread Isabella Ghiurea
Hello, How can I see all system catalog tables and views , I'm in potsgres db ( using PG 8.3). Is there a way to have /get a full list and description of system tables and views in kind of hard copy format, same as Oracle or RDBMS posters for system catalogs objects? thank you, Isabella -

[ADMIN] excluding tables from VACUUM ANALYZE

2008-10-28 Thread Igor Neyman
When I run "VACUUM ANALYZE" (or "vacuumdb -z") on the database, how can I exclude specific tables from being analyzed? Igor