Default search path

It is always good practice to use a fully qualified name when revoking or granting rights; otherwise, you may be inadvertently working with the wrong table.

To see the effective search path for the current database, run the following:

pguser=# show search_path ;
  search_path  
----------------
 “$user”,public
(1 row)

To see which table will be affected if you omit the schema name, run the following in psql:

pguser=# \d x
     Table “public.x”
 Column | Type | Modifiers
--------+------+-----------

The public.x table name in the response contains the full name, including the schema.