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

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

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.futrelle@xxxxxxxxx>:

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