I'm trying to do what I think is an outer-join:
SELECT
da.datname as database,
de.description as comment
FROM
pg_database as da,
pg_description as de
WHERE
(da.oid = de.objoid)
Obviously, if there are no descriptions, no values will be returned.
What I want is to display all databases, with comments (valid or null).
How do I form the WHERE clause?
Thanks,
Brad Matlack
matlackb(at)ogden(dot)disa(dot)mil