Re: [SQL] list of tables?

From: "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: pgsql-sql(at)postgreSQL(dot)org, "Rosauro, Guillaume" <Guillaume(dot)Rosauro(at)matra-com(dot)fr>
Subject: Re: [SQL] list of tables?
Date: 1998-05-21 09:26:52
Message-ID: Pine.LNX.3.96.980521092612.361A-100000@proxy.bazzanese.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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'

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Oleg Broytmann 1998-05-21 09:30:09 Re: [SQL] list of tables?
Previous Message The Hermit Hacker 1998-05-21 02:03:18 list of tables?