Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #832

Query regarding psql command

Show all headers | View raw

Hi there,
I'm an undergrad student and very new to postgresql. I have a question to which I haven't been able to find an answer yet.
I installed postgresql and ran the command `psql -U postgres` and as expected it failed because the role doesn't exist.

But when I tried to run `psql postgres`, it worked! My question is why is this command working? I've not been able to find this command anywhere in the documentation.

Now, I also created the role postgres and both commands are working.

Note: when I run `psql postgres` the logged-in user is the superuser to OS. I'm doing this on High Sierra.

Back to comp.databases.postgresql | Previous | Next — Next in thread | Find similar

Thread

Query regarding psql command ajat.prabha.leo@gmail.com - 2018-05-24 23:34 -0700
  Re: Query regarding psql command Laurenz Albe <laurenz@nospam.pn> - 2018-05-25 11:05 +0000
    Re: Query regarding psql command ajat.prabha.leo@gmail.com - 2018-05-25 05:25 -0700

csiph-web