Hi,

2009/4/16 Jürgen E. <[email protected]>:
> select * from geometry_columns,pg_class,pg_namespace where 
> relname=f_table_name and f_table_schema=nspname and pg_namespace.oid = 
> pg_class.relnamespace and has_schema_privilege(pg_namespace.nspname,'usage') 
> and 
> has_table_privilege('"'||pg_namespace.nspname||'"."'||pg_class.relname||'"','select')
>  order by f_table_schema,f_table_name

thanks, it helped. Martin

-- 
Martin Landa <landa.martin gmail.com> * http://gama.fsv.cvut.cz/~landa
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to