"Louis Lam" <[email protected]> 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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general