Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA12449; Wed, 1 Apr 92 07:01:09 -0800
Date: Wed, 1 Apr 92 07:01:09 -0800
From: cartaxo@dpi.inpe.br (Ricardo Cartaxo)
Subject: "dir"-like query
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
To: postgres@postgres.berkeley.edu
Message-Id: <9204011346.AA05844@dpi.inpe.br>
X-Envelope-To: postgres@postgres.berkeley.edu

Hi,
Is there a way to query all databases, tables, attributes and their types, belon
   ging to certain user?
I can see no relationship between pg_database and pg_class. I mean, the pg_class
    attribute "relowner"  should not indicate the pg_database attribute "datdba"
    which is the same as the pg_user attribute "oid" ?
All classes seems to be owned by postgres and template1.
Thanks in advance.

JoaoPedro
jamp@inpe.dpi.br