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=#
Share

You may also like...