Hi Bob:
On Sat, May 30, 2015 at 1:48 PM, Bob Futrelle bob.futre...@gmail.com wrote:
Using pgAdmin3 I've tried this and variations on it. All are rejected.
select COMMENT ON TABLE articlestats
pgAdmin3 is a bit complex for me, bot on vanilla psql you can use the switch:
-E
--echo-hidden
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
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
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
On 05/30/2015 04:48 AM, Bob Futrelle wrote:
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:
select obj_description('table1'::regclass, 'pg_class');
That will only show the table comment.
My query shows that table comment AND any column comments!
On Sat, May 30, 2015 at 9:37 AM, Adrian Klaver adrian.kla...@aklaver.com
wrote:
On 05/30/2015 04:48 AM, Bob Futrelle wrote:
Using