Psql initialization

psql -U postgres

# Postgres "psql not recognized as an internal or external command"

# Just an update because I was trying it on Windows 10 you do need to set the 
# path to the following: 
# ;C:\Program Files\PostgreSQL\9.5\bin ;C:\Program Files\PostgreSQL\9.5\lib

# You can do that either through the CMD by using set PATH [the path] or from my
# computer => properties => advanced system settings 
# => Environment Variables => System Variables

# Then search for path.

# Important: don't replace the PATHs that are already there just add one 
# beside them as follows 
# ;C:\Program Files\PostgreSQL\9.5\bin ;C:\Program Files\PostgreSQL\9.5\lib

# Please note: On windows 10, if you follow this: 
# computer => properties => advanced system settings 
# => Environment Variables => System Variables> select PATH, 
# you actually get the option to add new row. Click Edit, add 
# the /bin and /lib folder locations and save changes.

# Then close your command prompt if it's open and then start it again 
# try psql --version If it gives you an answer then you are good to go if 
# not try echo %PATH% and see if the path you set was added or not and if 
# it's added is it added correctly or not.

psql -U postgres
# enter your password and you are in

Source: stackoverflow.com

Similar codes

0 vote109 views1 answer
Get date ISO in psql
SQL
1 vote115 views1 answer
Mysql workbench in ubuntu 14.04
SQL
1 vote103 views1 answer
Alter table column size oracle
SQL
0 vote108 views1 answer
Copy data from one postgres container to another
SQL
0 vote102 views1 answer
What is the use of index in mysql table
SQL
1 vote94 views1 answer
How to delete a record from sqlite in android
SQL
0 vote92 views1 answer
Oracle 11g forget password
SQL
0 vote149 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
5 votes120 views6 answers
In operator sql
SQL
0 vote95 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL