Voici ses principaux champs :
Nom du champ | Type du champ | Description du champ |
description | text | Commentaire sur l'objet. |
oid | oid | Identifiant du commentaire. |
objoid | text | Identifiant de l'objet. |
SELECT
c.usename,
'',
'',
a.relname,
CASE a.relkind
WHEN 'v' THEN 3
ELSE 2
END,
b.description
FROM pg_class a LEFT JOIN pg_description b ON b.objoid=a.oid AND b.objsubid=0, pg_user c
WHERE
c.usesysid=a.relowner
AND a.relkind IN ('r', 'v')
AND b.usename LIKE 'MonProprietaire%'
AND a.relname LIKE 'MaTable%'
ORDER BY c.usename, a.relname;