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 <[email protected]>
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_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users
