I'm writing a foreign data wrapper program as a PostgreSQL extension. Is there any way to get the comment string set in the extension control file from my C program? The comment was created by PostgreSQL when I ran CREATE EXTENSION myFDW.

1 Answer 1


You can get the comment for an extension by querying the pg_description and the pg_extension system catalogs:

SELECT d.description
FROM pg_description AS d
   JOIN pg_extension AS e ON d.objoid = e.oid
WHERE d.classoid = 'pg_extension'::regclass
  AND e.extname = 'myfdw';

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.