{"id":100,"date":"2017-04-07T12:54:12","date_gmt":"2017-04-07T12:54:12","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=100"},"modified":"2017-04-14T08:42:53","modified_gmt":"2017-04-14T08:42:53","slug":"documenting-your-postgresql-database","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2017\/04\/07\/documenting-your-postgresql-database\/","title":{"rendered":"Documenting your PostgreSQL database"},"content":{"rendered":"

PostgreSQL has a pretty nifty feature to add comments to database objects, using the COMMENT<\/a> function. \u00a0You can pretty much add comments to almost any objects, like tables, view, foreign keys, constraints, columns, etc.<\/p>\n

You add a comment using the COMMENT ON … function, then retrieve the comment using the obj_description<\/a> function for most objects. \u00a0For columns, you’ll need to use the col_description<\/a> function.<\/p>\n

\"\"<\/p>\n

All this is rather tedious if you plan to add\/remove comments for a lot of objects. \u00a0To make this task easier, we have recently released a free product, PgComment<\/a>, downloadable here<\/a>. \u00a0With PgComment<\/a>, you just connect to your database and the application will list out all the comments attached to your tables, columns, indexes, views, sequences, domains, and functions.<\/p>\n

\"\"<\/p>\n

You can then easily modify the comments, and apply them to the database. \u00a0Changes are cached, and sent to the server in a single batch, allowing for faster editing locally. \u00a0With the schema displayed in a hierarchical tree, you get an overview of what’s been commented and what has not. \u00a0This makes it so much easier to document your PostgreSQL database.<\/p>\n

Another feature of PgComment is that you can view the properties of your database objects. \u00a0For tables, you can see details like the owner, total size, index size, estimated rows etc.<\/p>\n

\"\"<\/p>\n

For indexes, you can see details like the index definition, index size, and various other properties.<\/p>\n

\"\"<\/p>\n

Displaying these properties should help you write better comments for your objects.<\/p>\n

If you want to generate PDF or HTML reports of your PostgreSQL database schema, take a look at\u00a0DB Doc<\/a>. \u00a0With DB Doc<\/a>, you can generate customizable PDF and HTML schema reports in just a few clicks.<\/p>\n

<\/fb:like><\/div>
<\/div><\/div>","protected":false},"excerpt":{"rendered":"

PostgreSQL has a pretty nifty feature to add comments to database objects, using the COMMENT function. \u00a0You can pretty much add comments to almost any objects, like tables, view, foreign keys, constraints, columns, etc. You add a comment using the COMMENT ON … function, then retrieve the comment using the obj_description function for most objects. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[6,22],"tags":[3,23],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/100"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=100"}],"version-history":[{"count":4,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/100\/revisions"}],"predecessor-version":[{"id":111,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/100\/revisions\/111"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}