When you install a PolarDB for PostgreSQL(Compatible with Oracle), 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:
SHOW SEARCH_PATH;
You can use the statements in PSQL to alter the search path.