Thread: list of non-printing table

Howdy:

I'm running PostgreSQL 7.2.1 on RedHat Linux 7.2.

I am trying to get a list of tables that does not have a
description, but I am unsure about how to do this.

I have a query:

[snip]

select
-- distinct
a.relname as "name of table",
a.oid,
b.description as "table description",
c.usename as "owner"
from
pg_class a,
pg_description b,
pg_user c
where
a.oid = b.objoid
and a.relkind = 'r'
and a.relname ~ '[A-Za-z]'
--and a.relname like 'test200%'
and a.relname not like 'pg_%'
and a.relowner = c.usesysid
-- and b.description
order by
a.relname
;

[/snip]

where the results will be a list of tables that exist and
have descriptions.  However, I can see from the list a
lot of tables that does exist but does not have a description
next to it.  I want the latter.

I thought about trying to generate two lists, maybe by means
of a join, to match one list against the other (full list of tables
vs. list of tables with actual description).  Althought that might
work, I was hoping there was some shorter way to
say:

[snip]

...
where b.description is null
or
where b.descripton = ''

[/snip]

As a note: the above portions does not seem to work
for me.

Suggestions?

Thanks!

-X