[postgis-users] Where is comment data stored in PostGIS?

[Eloi Ribeiro]

Hi,

This is one way of getting the comments stored in PostgreSQL.

SELECT relname, obj_description(oid)

FROM pg_class

WHERE relkind = 'r'

     AND obj_description(oid) IS NOT NULL;

More info here: https://stackoverflow.com/questions/5664094/getting-list-of-table-comments-in-postgresql#5664217

Eloi

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Thursday, September 5, 2019 11:25 AM, Shaozhong SHI <shishaozhong at gmail.com> wrote:

> Hi,
>
> Where is comment data stored in PostGIS?
>
> One can type in text in the comment box.  Where is this content be stored?  Can the content be accessed by other desktop applications?
>
> For instance, can ArcGIS import this content as metadata?
>
> Looking forward to hearing from you.
>
> Regards,
>
> Shao
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190906/ebbe974b/attachment.html>