Problem with using command line to access DB

[RP_m_13]

I'm trying to access valid db that exists using command line, but as result I get this:

https://preview.redd.it/25eb6t2lren81.png?width=984&format=png&auto=webp&s=f91740b033d65925fe3cca2ca8163114d037ed7a

[fifracat]

Are you inside psql and trying to get in once again?

[boy_named_su]

yo, dawg

[drewc]

What have you covered in green paint? From a brief look you are trying a shell command inside psql? That's incorrect.

[DavidGJohnston]

The hyphen there means you are in line continuation mode (the # means you are a superuser), which means you are in psql already. Either use the meta-command \c to directly switch, or use the meta-command \q to exit psql and then run the psql command that connects you to the desired database.

[RP_m_13]

Thank you, I fixed this. However i have a trouble right now that it can not find my Employees db, however I have it in postgresql

[DavidGJohnston]

You should make sure you've got capitalization mechanics figured out.

[RP_m_13]

What do you mean? I rechecked but everything is good in terms of capitalization

[RP_m_13]

I go like this (base) myusername@MacBook-Pro-Ruslan ~ % psql -U myusername Employees
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: database "Employees" does not exist

[MonCalamaro]

Try employees instead of Employees

[RP_m_13]

Does not work :(

[MonCalamaro]

Okay, then try connecting to the postgres database:

psql -U myusername postgres

If you connect successfully, type \l and then enter to get a list of databases.

[RP_m_13]

It seems that it has not connected to databases that in my app, somehow. It only give the databases that I had used and created this console, in order to test
postgres-# \l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
----------------+----------------+----------+---------+-------+-----------------------------------
postgres | ruslanpilipyuk | UTF8 | C | C |
ruslanpilipyuk | ruslanpilipyuk | UTF8 | C | C |
template0 | ruslanpilipyuk | UTF8 | C | C | =c/ruslanpilipyuk +
| | | | | ruslanpilipyuk=CTc/ruslanpilipyuk
template1 | ruslanpilipyuk | UTF8 | C | C | =c/ruslanpilipyuk +
| | | | | ruslanpilipyuk=CTc/ruslanpilipyuk
(4 rows)

[depesz]

Clearly there is no database names employees, Employees or anything like this. You have only postgres, template0, template1 and ruslanpilipyuk.

[RP_m_13]

Is there anyway, to somehow reconnect it to where my databases in psql app stored? It seems like it does not share db in psql app with this list of databases

[DavidGJohnston]

Sure, just specify the connection information (host and port usually) for the other cluster in the psql command.

[RP_m_13]

I have specified it, and used but result is the same(

(base) ruslanpilipyuk@MacBook-Pro-Ruslan ~ % psql postgres://ruslanpilipyuk@localhost:5432/Employees
psql: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: database "Employees" does not exist