Creating and switching schemas in PostgreSQL - Quick Revision & Summary

Recall & Review

beginner

What is a schema in PostgreSQL?

A schema is like a folder inside a database that holds tables and other objects. It helps organize data so you can keep things neat and separate.

beginner

How do you create a new schema named 'sales' in PostgreSQL?

Use the command: CREATE SCHEMA sales; This makes a new schema called 'sales' inside your database.

beginner

How can you switch to use a different schema in PostgreSQL?

You change the search path with: SET search_path TO schema_name; This tells PostgreSQL to look in that schema first when you run commands.

intermediate

What does the command SET search_path TO public, sales; do?

It tells PostgreSQL to look first in the 'public' schema, then in the 'sales' schema when searching for tables or other objects.

beginner

Why is using schemas helpful in a database?

Schemas help keep data organized, avoid name conflicts, and let different teams or projects work in the same database without mixing up their tables.

Which command creates a new schema called 'inventory'?

A MAKE SCHEMA inventory;

B NEW SCHEMA inventory;

C CREATE SCHEMA inventory;

D ADD SCHEMA inventory;

The correct syntax to create a schema is CREATE SCHEMA schema_name;.

How do you tell PostgreSQL to look in the 'marketing' schema first when running queries?

A CHANGE schema TO marketing;

B USE marketing;

C SET schema TO marketing;

D SET search_path TO marketing;

You use SET search_path TO schema_name; to set the schema search order.

If you run SET search_path TO sales, public;, which schema is checked first?

A sales

B None

C Both at the same time

D public

The first schema listed in search_path is checked first.

What is the default schema in PostgreSQL if you don't change the search path?

A sales

B public

C default

D main

By default, PostgreSQL uses the 'public' schema.

Why might you want to create multiple schemas in one database?

A To organize tables by project or team

B To make the database slower

C To delete data faster

D To avoid using tables

Schemas help organize data and avoid name conflicts by grouping tables logically.

Explain how to create a new schema and switch to it in PostgreSQL.

Think about making a folder and then telling the database to look inside it first.

Describe why using schemas can be helpful when multiple teams share the same database.

Imagine different teams having their own folders to keep their files separate.