Analyzing the database

After we have run the previous command, we can use the PostgreSQL command-line tools or any other application that allows us to easily check the contents of a PostreSQL database, to check the tables that Django generated. If you decided to continue working with SQLite, we already learned how to check the tables in the previous chapters.

Run the following command to list the generated tables:

psql --username=username --dbname=drones --command="\dt"

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

                   List of relations Schema |            Name            | Type  |  Owner   --------+----------------------------+-------+---------- public | auth_group                 | table | username public | auth_group_permissions     | table | username public | auth_permission            | table | username public | auth_user                  | table | username public | auth_user_groups           | table | username public | auth_user_user_permissions...