which table stores coordinates to the orgunits, querying the organisaztionunit table, no such column exists.
form version 3.32 coordinates column has been replaced by geometry in OrganisationUnit table.
This query will do the job:
SELECT name, ST_X(geometry) AS LONG, ST_Y(geometry) AS LAT FROM organisationunit where ST_GeometryType(geometry)=‘ST_Point’
@mutali Thank you, issue solved.