Home > mailing lists

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

From	Bob Futrelle
Subject	How to retrieve Comment text using SQL, not psql?
Date	May 30, 2015 14:48:55
Msg-id	CAOsWdXq01CaCyvD1v4-naYu_BmFjepLjxd7YQDPWe8eS62whuA@mail.gmail.com Whole thread Raw
Responses	Re: How to retrieve Comment text using SQL, not psql? Re: How to retrieve Comment text using SQL, not psql? Re: How to retrieve Comment text using SQL, not psql?
List	pgsql-general

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

From: Michael Paquier
Date: 30 May 2015, 11:00:46
Subject: Re: replacing jsonb field value

From: Pavel Stehule
Date: 30 May 2015, 14:59:45
Subject: Re: How to retrieve Comment text using SQL, not psql?