Voici ses principaux champs :
Nom du champ | Type du champ | Description du champ |
oid | oid | Identifiant du commentaire. |
nspname | text | Nom du schéma. |
SELECT
c.usename,
'',
a.nspname,
b.description
FROM pg_namespace a LEFT JOIN pg_description b ON b.objoid=a.oid, pg_user c
WHERE
a.nspowner=c.usesysid
AND c.usename LIKE 'MonProprietaire%'
AND a.nspname LIKE 'MonSchema%'
ORDER BY a.nspname;