Accessing the sample database v16

When EDB Postgres Advanced Server is installed, a sample database named edb is automatically created. This sample database contains the tables and programs used in this tutorial after you execute the script edb-sample.sql, located in the /usr/edb/as16/share directory.

This script does the following:

• Creates the sample tables and programs in the currently connected database
• Grants all permissions on the tables to the PUBLIC group

The tables and programs are created in the first schema of the search path in which the current user has permission to create tables and procedures. You can display the search path by issuing the command:

SHOW SEARCH_PATH;

You can alter the search path using commands in PSQL, a terminal-based front end to Postgres.