Using Database schemas

Database schemas (referred to as schema below) are a useful tool to group tables together and work in sets of data. They are supported in FAIR and also enable the use of multiple tables with the same name.

Setting or referencing a table

When setting the table schema or trying to refer to a table, it is important to also include the schema name in your script.

The schema name can be referred to using the syntax '[schema_name].[table_name]'.

Finding a schema

If a table belongs in a schema, this will be shown in the database list. The schema column is searchable using the Filter field at the top right hand side of the list.

If you have two tables with the same name, check you are referring to the right one using the schema the tables belong to.

Using the public schema

The public schema is the default one which belongs to the workspace itself. This is the schema which all tables belong to if they don't have another schema set. This schema does not show in the database list; each table which has a Blank in the schema column belongs in the public schema.

If needing to use a reference for a table in the public schema, use public.[table_name]

Importing tables in a schema

Importing tables from FAIR

When importing tables from FAIR data services, the schema they belong to will automatically be picked up if you're using the dataset import wizard.

If you're using a script to process your CSV files and create db tables then make sure to check that the schema is set; it can be referenced as described above.