What should the flow be for 'psql' command? Windows command line

Question

I can access psql with 'psql -U postgres' followed by the password, but I can't access my defined user with the same 'psql -U definedUser' it just says 'definedUser isn't a database'.

Just to clarify.

How do I log in as a predefined user? How do I quickly access psql from the command line?

use -d or --dbname to tell psql what database to use. The default is using the username also for the database name. https://www.postgresql.org/docs/current/app-psql.html — Frank Heikens, Sep 07 '22 at 13:35
Thanks Frank. Would it be ``` psql -U desiredUsername -d desiredDatabase ``` ? — Lauro235, Sep 07 '22 at 13:40
Yes, but I would avoid upper case in names and stick to just lower case. — Frank Heikens, Sep 07 '22 at 14:32

score 0 · Answer 1 · answered Sep 07 '22 at 13:35

Okay, I think I've figured it out. This comment is what swung it.. Very succinct and easy to solve. If the user has been created successfully, by default when you log in with said user psql attempts to find a database of the same name if it doesn't you get an error like 'desiredUsername isn't a database'.

You need to add the database name after the chosen username

psql -U desiredUsername desiredDatabase

https://stackoverflow.com/a/21827460/15592981

What should the flow be for 'psql' command? Windows command line

1 Answers1