Chapter 7 - Basic SQL Functions
“When I was 14, I thought my parents were the stupidest people in the world. When I was 21, I was amazed at how much they learned in seven years.”
- Mark Twain
Finding the Current Schema on the Leader Node
The CURRENT_SCHEMA function is a leader-node only function. In this example, the query does not reference a table, so it runs exclusively on the leader node in order to show the schema. Our Current_Schema is the public schema.
Getting Things Setup in Your Search Path
set search_path to '$user', 'public', 'sql_class', ...