Here is a summary, conclusions, and thoughts from the first chapter of Designing Data-Intensive Applications, with a few additions based on my experience.
Replace <part_of_table_name> with table name you are looking for. Since query uses like you can just pass partial of table name. Note that pg_table_def only returns information about tables that are visible to the user, so if you haven’t found what you are looking for, it does not mean that table does not exist.
export AWS profile with CLI