Databases · Junior · Question 63 of 75

What is a database 'schema' in the sense of PostgreSQL's `CREATE SCHEMA`?

✓Correct answer: A namespace inside a database that groups tables, views and functions
2A diagram drawn in a design tool
3A backup of the database structure

Explanation

By default objects live in the public schema. Schemas help separate modules or extensions, and they can have their own permissions.

Further reading

PostgreSQL: Privileges ↗

Test yourself

Take the Databases · Junior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.