Hands-On RESTful Python Web Services - Second Edition

Verifying the contents of the PostgreSQL database

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

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

psql --username=your_user_name --dbname=flask_notifications --command="\dt"

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

    
                          List of relations