"Louis Lam" <louis(dot)lam(at)guardium(dot)com> writes:
> Since you know this are well. Do you know if there is some kind of
> records filtering use by PostgreSQL when selecting system objects? For
> example, I run this query by PostgreSQL user.
> select count(*) from information_schema.table_privileges;
The information_schema views filter out information about objects that
you don't have any privileges for. This is required by SQL spec.
It's a bit pointless, since anybody can look at the underlying catalogs,
but we make them follow spec anyway.
regards, tom lane