On Tue, 14 Jan 2025 at 16:27, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
What I was suspicious of is whether you have "usage" privilege on the
schema that the postgis datatype is installed in. The above command
would not tell you that.
regards, tom lane
usage privilege exists:
teglms=# \dT geometry
List of data types
Schema | Name | Description
---------+----------+--------------------------------------------------------------------------------------
postgis | geometry | postgis type: The type representing spatial features with planar coordinate systems.
(1 row)
teglms=# \dn+ postgis
List of schemas
Name | Owner | Access privileges | Description
---------+------------+------------------------------+-------------
postgis | eglmsadmin | eglmsadmin=UC/eglmsadmin +|
| | gr_postgis_r=U/eglmsadmin +|
| | gr_postgis_rw=U/eglmsadmin +|
| | gr_postgis_rwx=UC/eglmsadmin |
(1 row)
br
Kaido
