This will give the comment on your table and any column: SELECT DISTINCT ON (c.relname) n.nspname as schema, c.relname, a.rolname as owner, 0 as col_seq, '' as column, d.description as comment FROM pg_class c LEFT JOIN pg_attribute col ON (col.attrelid = c.oid) LEFT JOIN pg_description d ON (d.objoid = col.attrelid AND d.objsubid = 0) JOIN pg_namespace n ON (n.oid = c.relnamespace) JOIN pg_authid a ON ( a.OID = c.relowner ) WHERE n.nspname NOT LIKE 'information%' AND relname NOT LIKE 'pg_%' AND relname NOT LIKE 'information%' AND relname NOT LIKE 'sql_%' AND relname = 'articlestats' AND relkind = 'r' AND d.description IS NOT NULL UNION SELECT n.nspname as schema, c.relname, '' as owner, col.attnum as col_seq, col.attname as column, d.description FROM pg_class c JOIN pg_attribute col ON (col.attrelid = c.oid) LEFT JOIN pg_description d ON (d.objoid = col.attrelid AND d.objsubid = col.attnum) JOIN pg_namespace n ON (n.oid = c.relnamespace) JOIN pg_authid a ON ( a.OID = c.relowner ) WHERE n.nspname NOT LIKE 'information%' AND relname NOT LIKE 'pg_%' AND relname NOT LIKE 'information%' AND relname NOT LIKE 'sql_%' AND relname = 'articlestats' AND relkind = 'r' AND d.description IS NOT NULL AND col.attnum >= 0 ORDER BY 1, 2, 4;
Learn the catalogs and you will learn PostgreSQL! On Sat, May 30, 2015 at 7:58 AM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > 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.futre...@gmail.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 >> >> > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.