Received: from proxy.bazzanese.com (root@ip198.tol11.interbusiness.it [195.120.106.198]) by hub.org (8.8.8/8.7.5) with ESMTP id EAA29866 for ; Thu, 21 May 1998 04:08:38 -0400 (EDT) Received: from localhost (sferac@localhost) by proxy.bazzanese.com (8.8.8/8.8.8/Debian/GNU) with SMTP id JAA00387; Thu, 21 May 1998 09:26:52 GMT Date: Thu, 21 May 1998 09:26:52 +0000 (UTC) From: "Jose' Soares Da Silva" X-Sender: sferac@proxy.bazzanese.com To: The Hermit Hacker cc: pgsql-sql@postgreSQL.org, "Rosauro, Guillaume" Subject: Re: [SQL] list of tables? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Wed, 20 May 1998, The Hermit Hacker wrote: > > Hello > > I d like to know if it is possible to have the list of tables like we can do with psql with \dt > > thanks > -- list all and only tables/views... SELECT usename, relname FROM pg_class, pg_user WHERE ( relkind = 'r') AND relname !~ '^pg_' AND relname !~ '^xin[vx][0-9]+' AND usesysid = relowner ORDER BY relname; Jose'