'How to see a SQL table's comment in CLI?

Let say I have a schema world and a table city in a Postgres DB. I can set a comment on the table (or view, function, index, ...) with the command below:

COMMENT ON TABLE world.city IS 'This is a test comment';

How can I see this comment in CLI (Not GUI)? I tried using show command thinking it might help, but got a syntax error!

SHOW TABLE world.city;  
ERROR:  syntax error at or near "table"  
LINE 1: show table world.city;

The same happened with show command on views!

postgresql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions