Re: [SQL] list of tables? - Mailing list 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'