[postgis-users] geometry_columns and privileges?

Martin Landa landa.martin at gmail.com
Sat Aug 2 07:50:25 PDT 2014


I am using PostGIS 2.1 and I found out strange problem when checking
content of `geometry_columns` table.

Locally it works:

psql db -c"select count(*) from geometry_columns"

But remotely (different machine, different user) the number of records is zero:

psql db -h host -U user -W -c"select count(*) from geometry_columns"

BTW, the user 'user' is owner of DB 'db'.'

Any idea what could be wrong? Thanks, Martin

Martin Landa * http://geo.fsv.cvut.cz/gwiki/Landa

More information about the postgis-users mailing list