Re: How to retrieve Comment text using SQL, not psql?

Hi

you can call function obj_description
http://stackoverflow.com/questions/11493978/how-to-retrieve-the-comment-of-a-postgresql-database

http://www.postgresql.org/docs/9.1/static/functions-info.html

For tables

SELECT pg_catalog.obj_description('tablename'::regclass, 'pg_class') as
"Description;

Regards

Pavel Stehule

2015-05-30 13:48 GMT+02:00 Bob Futrelle <bob(dot)futrelle(at)gmail(dot)com>:

> Using pgAdmin3 I've tried this and variations on it. All are rejected.
>
> select COMMENT ON TABLE articlestats
>
>
> No answer here,
>
> http://www.postgresql.org/docs/9.3/static/sql-comment.html
>
>
> pgAdmin3 had no problem with entering a comment:
>
> COMMENT ON TABLE articlestats IS 'Comprehensive data for every article.'
>
>
> - Bob Futrelle
>
>