Connecting to postgres database with username concurrently
You can select your database from command prompt itself at the time when you login to your database. Example :
E:\postgre\bin> psql -h localhost -p 5432 -U postgres data1 Password for user postgres: psql (8.4.22) WARNING: Console code page (437) differs from Windows code page (1252) 8-bit characters might not work correctly. See psql reference page "Notes for Windows users" for details. Type "help" for help. data1=#