What command we need to use to list all tables inside the specific schema ?

Suppose if the schema name is my_data, then we need to use the following command to list all the tables inside the my_data schema.

\dt my_data.*

Now, if you want to create a new table inside the my_data schema, we just need to prefix the table name with the schema name like this.

CREATE TABLE my_data.students (
    id SERIAL PRIMARY KEY,
    name TEXT NOT NULL,
    age INT,
    enrolled_on DATE DEFAULT CURRENT_DATE
);

This will create the students table inside the my_data schema.