Accessing the schema

Most modern databases can be divided up into “schemas”. The Smile public schema is defined in a specific schema in the Smile database engine. The Smile public schema is called “smile02”. If we release an incompatible version of the schema in the future, then we will do so using a different schema name. Where possible, we will not remove the older schemas.

For interactive queries, the easiest way to access the tables and views is to set the schema search path using this psql interactive command:

set search_path=smile02;

With the search_path set to smile02, you will not need to prefix the table names with “smile02” schema name. For example, to list all accounts in Smile, you could use a query such as:

SELECT * FROM account;

For reporting tools, if you can not set the search path in the reporting tool, then you may need to use the fully qualified table name when performing queries. For example, to list all accounts in Smile, you may need to use a query such as:

SELECT * FROM smile02.account;