Schemas for namespace organization in PostgreSQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a schema in PostgreSQL?

A schema is a way to organize database objects like tables and views into separate namespaces, helping avoid name conflicts and grouping related objects.

beginner

How does a schema help with namespace organization?

Schemas create separate containers for objects, so two tables with the same name can exist in different schemas without conflict.

beginner

How do you create a new schema in PostgreSQL?

Use the command CREATE SCHEMA schema_name; to create a new schema.

beginner

How do you refer to a table inside a specific schema?

Use schema_name.table_name to specify the schema and table, like sales.customers.

beginner

What is the default schema in PostgreSQL if none is specified?

The default schema is public. If you don’t specify a schema, PostgreSQL looks in public.

What does a schema in PostgreSQL help organize?

A Operating system files

B Only user accounts

C Database objects like tables and views

D Network connections

Schemas organize database objects such as tables and views into namespaces.

Which command creates a new schema named 'inventory'?

A CREATE TABLE inventory;

B MAKE SCHEMA inventory;

C NEW SCHEMA inventory;

D CREATE SCHEMA inventory;

The correct syntax to create a schema is CREATE SCHEMA followed by the schema name.

How do you refer to a table named 'orders' inside the 'sales' schema?

A sales.orders

B orders.sales

C orders:sales

D sales-orders

The correct format is schema_name.table_name, so sales.orders.

What is the default schema in PostgreSQL?

A default

B public

C system

D main

PostgreSQL uses the public schema by default if no schema is specified.

Why use schemas in a database?

A To organize objects and avoid name conflicts

B To store backups

C To speed up queries

D To encrypt data

Schemas help organize database objects and prevent name conflicts by grouping objects into namespaces.

Explain what a schema is and how it helps organize database objects in PostgreSQL.

Think about how folders organize files on your computer.

Describe how to create a schema and how to reference a table inside that schema.

Remember the syntax for creating and using schemas.