When you install a PolarDB-O, a sample database is automatically created. This sample
database contains the tables and programs used in this topic. This database runs the
sample.sql script in the /u01/polardb/share/ directory.
This script supports the following features:
- Creates the sample tables and programs in a connected database.
- Grants all permissions on tables to the PUBLIC group.
The tables and programs are created in the first schema of the search path in which the current user is authorized to create tables and procedures. You can run the following statement to display the search path:
You can use the statements in PSQL to alter the search path.