Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- When working with a schema different from public - e.g., employees, -
- to avoid having to specify the schema like "select * from employees.names" every time
- */
- SET search_path TO employees,public;
- /*
- Now we can write "select * from names"
- SRC: https://www.postgresql.org/docs/current/ddl-schemas.html#DDL-SCHEMAS-PATH
- */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement