5.1 Check Data in RDS

Check Data in RDS

  1. Use the command to access PostgreSQL from the previous step.
psql -U postgres -h <YOUR_POSTGRESQL_DNS> -p 5432 -d postgres

  1. If you see a message like the one below, you have successfully connected to the PostgreSQL database. alt

  2. Run the following command to check data in the orders table:

SELECT * FROM orders;
  1. Run the following command to check data in the order_details table:
SELECT * FROM order_details;
  1. Below is an example image of the orders table; your data may differ due to randomness.

alt

  1. Below is an example image of the order_details table; your data may differ due to randomness.

alt

  1. Type \q to exit the PostgreSQL database and return to the terminal.

  2. You have now completed checking data in RDS. You can use other SQL commands to check data in tables such as users, products, or perform more complex queries.