How to open a table in a database?

Question

SQL

I entered the database as a user, I need to see the contents of the "Couriers" table, I view the contents of the database with the \dt command.
Then I made a simple SQL query - SELECT * FROM Couriers; and gives an error - ERROR: relation "couriers" does not exist

Answer 1

Obviously psql on the screen, respectively postgresql.
The command line prompt -# indicates that this is no longer the beginning of a query, but that you have already typed something earlier. And psql thinks that you are writing the query further, then sends it in its entirety. Commands from psql itself are treated in the same way.
LINE 2 says the same thing.
According to the tables - pay attention to the register . from couriers and from couriers refer to the couriers table. A case-sensitive name is syntactically different by the standard.

Answer 2

Where are you copying the request from?
You have SELECT - the second line, before it - something non-printable. Beat with your hands.

Answer 3

USE название_БД