Re: Monitoring database

Yes I would like to see system tables, that is correct is there any way to see all those tables.
For example in MySQL there is mysql database where you have all system tables.

David Stanaway wrote:

On Tuesday, January 15, 2002, at 07:08 PM, Roman Gavrilov wrote:

          David Stanaway wrote:

          On Wednesday, January 9, 2002, at 10:31 PM, Roman Gavrilov wrote:

                    One more question is how can I see all tables in the template1 ?
                    Thanks allot.

          in the psql client: psql template1
          \dt
          \h is definately worth reading too.
 

     Did you try that ?
     I get  "No relations found" is it a problem or template1 tables are protected some how and not shown in \dt

What relations are you looking for? System tables? They don't show up in \dt That just lists user tables.
There are a number of \d<X> commands in psql for different types of relations, you should look at \? (Sorry I said \h and thats for SQL help) to see all the psql escapes.

==============================
David Stanaway
Personal: david@stanaway.net
Work: david@netventures.com.au

-- 
-----------------------------------------------------------------------------
 Roman Gavrilov                           
 Aduva Inc., Web Development Services.    
 work +972-3-7534324 mobile +972-54-834668
 romio@aduva.com, romio@netvision.net.il