Postgres and user search paths

setpsqluserpath.md

Set the search path for a postgresql user

By default, the search path for a PostgreSQL user is set to the "public" schema. Even if you create a new schema (say, "import") any tables you create in it will not show up in a dt listing of tables without also specifying the schema (e,g,, \dt import.*).

Fix is to update the user's path to include the new schema:

postgres=# alter role myuser set search_path = '$user',public,import;