Hi Bob:
On Sat, May 30, 2015 at 1:48 PM, Bob Futrelle <bob.futrelle@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
Echo the actual queries generated by \d and other backslash commands.
You can use this to study psql's internal operations. This is
equivalent to setting the variable ECHO_HIDDEN to on.
<<<
to learn how it does them, and elaborate from there, Its a nice
resource ( although I fear its queries evolve with versions, but you
can always port them touse the information_schema (
http://www.postgresql.org/docs/9.4/static/information-schema.html )
which should be a little more stable.
Francisco Olarte.