May 2018
Intermediate to advanced
576 pages
30h 25m
English
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.