Re: Monitoring database

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


<excerpt><excerpt>David Stanaway wrote:


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

<excerpt>     One more question is how can I see all tables in the
template1 ?

     Thanks allot.

</excerpt>

in the psql client: psql template1

\dt

\h is definately worth reading too.

</excerpt> 

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

</excerpt>

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.




<fontfamily><param>Helvetica</param>==============================

David Stanaway

Personal: david@stanaway.net

Work: david@netventures.com.au</fontfamily>
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