Advertisement
NonplayerCharacter

PostgreSQL | Relation does not exist, set search_path

Feb 23rd, 2023
1,388
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. /*
  2. When working with a schema different from public - e.g., employees, -
  3. to avoid having to specify the schema like "select * from employees.names" every time
  4. */
  5.  
  6. SET search_path TO employees,public;
  7.  
  8. /*
  9. Now we can write "select * from names"
  10. SRC: https://www.postgresql.org/docs/current/ddl-schemas.html#DDL-SCHEMAS-PATH
  11. */
Tags: postgresql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement