John R Pierce wrote:
> better would be to...
>
> ALTER ROLE username SET SEARCH_PATH='preview,"$user", public';
> or
> ALTER DATABASE dbname SET...;
>
> and then this change just applies to that named role or database...
(or
ALTER ROLE username IN DATABASE dbname SET ..
which applies to the specified role in the specified database)
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services