Home > mailing lists

Re: How to retrieve Comment text using SQL, not psql? - Mailing list pgsql-general

From	Pavel Stehule
Subject	Re: How to retrieve Comment text using SQL, not psql?
Date	May 30, 2015 14:59:45
Msg-id	CAFj8pRAQP1akToqT_0qWtgVuv1HYdBsyo7a4dM59XMyCHTz9RQ@mail.gmail.com Whole thread Raw
In response to	How to retrieve Comment text using SQL, not psql? (Bob Futrelle <bob.futrelle@gmail.com>)
Responses	Re: How to retrieve Comment text using SQL, not psql?
List	pgsql-general

Tree view

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@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

pgsql-general by date:

From: Bob Futrelle
Date: 30 May 2015, 14:48:55
Subject: How to retrieve Comment text using SQL, not psql?

From: Andreas Kretschmer
Date: 30 May 2015, 15:10:15
Subject: Re: replacing jsonb field value

Re: How to retrieve Comment text using SQL, not psql? - Mailing list pgsql-general

Previous

Next