Hands-On RESTful Python Web Services - Second Edition

Verifying the contents of the PostgreSQL database

After we run the previous command, we can use the PostgreSQL command line or any other application that allows us to easily check the contents of the PostgreSQL 10.5 database to check the tables that Django generated.

Run the following command to list the generated tables. If the database name you are using is not named django_games, make sure you use the appropriate database name. The code file for the sample is included in the restful_python_2_06_01 folder, in the Django01/cmd/list_database_tables.sql file:

    psql --username=your_games_user_name --dbname=django_games --    command="\dt"
  

The following lines show the output with all the generated table names:

                             List of relations
     Schema | Name ...