O'Reilly logo

Actian Matrix (Formely ParAccel) - Architecture and SQL by Ed Bernier, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

image

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

image

set search_path to '$user', 'public', 'sql_class', ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required