Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

6
  • 30
    Also worth noting to explicitly NOT use quotes around the a,b,c enumeration. Hand-to-forehead for the past 15 minutes... Commented Mar 5, 2016 at 12:51
  • 7
    @Jmoney38 Not to use single quotes, but double-quotes are required for non-simple schema names. Commented Apr 17, 2018 at 23:55
  • 1
    Yes, those are identifiers, not strings. Commented Aug 27, 2020 at 7:15
  • 4
    For me a reconnect to the database was necessary. SHOW SEARCH_PATH right after the ALTER ROLE seemed like it didn´t work at first.. Commented Apr 10, 2022 at 17:53
  • I don't recommend using this command because it will modify the search_path for all databases that the role has access on. I would advise using ALTER DATABASE <data_base> set search_path TO a,b,c; Commented Oct 10, 2022 at 11:42