Command c connect asks password I did not create [Postgres]

Asked

Viewed 58 times

-1

Hi, I created the table 

controle_compras

and it all worked out. I inserted items as indicated in the class, but only as an exercise, I started to create another table only to train the commands. But when I decided to do c connect controle_shopping; it appears like this:

postgres=# \c connect controle_compras;
Senha para usuário controle_compras:
FATAL:  password authentication failed for user "controle_compras"
Conexão anterior mantida
postgres=#

The problem is that in no time, I have set password for this BD. I even tried to use the general password that connects to the BDS but it didn’t work. I know that probably the mistake must be bullshit. But I am very beginner.qu

postgresql psql

  • In psql the command for connection to a database is either c or connect. In his case he assumed that dbname is connect and controle_purchases the username. See psql help.

1 answer

0

solved. I removed connect. So to connect to db controle_shopping I used \c controle_compras;

Browser other questions tagged postgresql psql

You are not signed in. Login or sign up in order to post.