From: | Roman Gavrilov <romio(at)il(dot)aduva(dot)com> |
---|---|
To: | David Stanaway <david(at)netventures(dot)com(dot)au> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Monitoring database |
Date: | 2002-01-16 08:09:17 |
Message-ID: | 3C45352D.D95F430@il.aduva.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)stanaway(dot)net
> Work: david(at)netventures(dot)com(dot)au
--
-----------------------------------------------------------------------------
Roman Gavrilov
Aduva Inc., Web Development Services.
work +972-3-7534324 mobile +972-54-834668
romio(at)aduva(dot)com, romio(at)netvision(dot)net(dot)il
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Boes | 2002-01-16 13:39:43 | Re: VACUUM ANALYZE--how often? |
Previous Message | juerg.rietmann | 2002-01-16 07:50:24 | postgreSQL Version 7.2 for SuSE Linux |