1. Learn
    2. /
  2. Courses
    3. /
  3. Creating PostgreSQL Databases

Exercise

The public schema

The public schema of a PostgreSQL database is created by default when a new database is created. All users by default have access to this schema unless this access is explicitly restricted. When a database is going to be used by a single user and does not have complex groupings of data objects beyond what can naturally be supported by an object-relational database, the public schema will usually suffice. No additional schemas need to be added to such a database. This exercise will help to reinforce the idea that the public schema can be ignored in most basic usage of PostgreSQL.

Instructions

100 XP
  • Imagine that you are currently using the pod database described in previous lessons. Create a table named users (to represent listeners of podcasts on the platform) to the pod database such that it is added to the public schema.