How To Retrieve PostgreSQL schema comments

Question

I would like to version control PostgreSQL schemas with the COMMENT ON syntax (whether that's a good practice is another question) but I'm not sure how to retrieve these comments later on.

There's quite some writing around how to retrieve database and column comments, not so much about schemas.

Any ideas?

See https://stackoverflow.com/questions/11493978/how-to-retrieve-the-comment-of-a-postgresql-database — Stefan, Feb 25 '20 at 08:05

score 8 · Answer 1 · answered Jul 11 '17 at 07:26

8

SELECT obj_description('public'::regnamespace, 'pg_namespace');

answered Jul 11 '17 at 07:26

Nick Barnes

19,816
3
51
63

score 1 · Accepted Answer · answered Jul 11 '17 at 07:38

1

To retrieve Schema comments, you can use psql utility. The comments can be viewed with \dn+ in the prompt. Comments are stored in the Description Column.

answered Jul 11 '17 at 07:38

Lohit Gupta

1,045
6
11

How To Retrieve PostgreSQL schema comments

2 Answers2