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 Schema | Name | Type | Owner --------+-----------------------+-------+---------------- public | alembic_version | table | your_user_name public | notification | table | your_user_name public | notification_category...