![postgresql psequel for windows postgresql psequel for windows](https://idrawone.github.io/images/img/win-pro-4.png)
#Postgresql psequel for windows windows 10
Soon after providing the correct password for the specified user account, you will immediately enter the PostgreSQL environment while staying within Windows 10 command prompt. For the default user account, you are requested to create a password for accessing it during the PostgreSQL server’s installation therefore, in this case, we will be providing that password that we had set up for the default user account during the installation of the PostgreSQL server on our Windows 10 system. When you run the above-mentioned command, you will be asked to provide your specified user account password. If you have also not created a new user, then your default username will also be “postgres”. However, since we did not create any new user for our PostgreSQL server, we will have to access the PostgreSQL environment through the user-created by default during the installation. During the installation of the PostgreSQL server, and even after that, you can create a new user. Here, “postgres” represents the default username for the PostgreSQL server. For that, you need to run the command shown below: Now, you need to access the PostgreSQL environment through Windows 10 command prompt. Step # 3: Enter the PostgreSQL Environment through the Command Prompt:
![postgresql psequel for windows postgresql psequel for windows](https://www.thesmbguide.com/images/postgresql-1024x512-20190322.png)
Initially, no commands will be executed, but you will see how you can run commands within Windows 10 command prompt in the following step. The default Command Prompt window of our Windows 10 system is shown below. You will instantly be able to see the Command Prompt result on which you need to click for launching it. For that, you have to use the Windows 10 search bar again and look for “cmd” in it. Once you have correctly set up the required environment variable for your PostgreSQL server, the next step is to launch the command prompt on Windows 10. Step # 2: Access the Command Prompt through your Windows 10 System: After that, you can also close the System Properties window. After adding this path, you can proceed further by clicking on the “OK” button. Here, you need to copy and paste the path of your PostgreSQL server’s bin directory at the specified location. This will let you add the Path of your PostgreSQL server’s bin directory to the PATH environment variable so that the PostgreSQL environment can be accessed easily from the Windows 10 command prompt.įrom the PATH environment variable, you need to click on the “New” button so that you can add a new path to it. Then, go to the System variables section and double click on the Path option located over there. In that tab, you need to locate the Environment Variables button and click on it. You need to click on the third tab named the “Advanced” tab within this window. For setting up the required environment variable, you have to type “env” in your Windows 10 search bar and click on the “Edit the system environment variables” result.Īfter choosing this option, the System Properties window will pop up on your screen. Otherwise, you will face issues while accessing the PostgreSQL environment on your system. Step # 1: Set up the Environment Variable of your Windows 10 System:īefore starting to use the Windows 10 command prompt for accessing the PostgreSQL environment, you need to set up your system’s environment variable. However, we would like to state over here that you should first read all of these steps thoroughly and then start performing them so that you can accomplish the desired task correctly without making any mistakes.
#Postgresql psequel for windows how to
How to connect to the PostgreSQL Database through Windows 10 Command Line Interface (CLI)?įor connecting to any desired PostgreSQL database through Windows 10 CLI, you will have to perform the following five steps, whereas the sixth one is optional. Note: You can also play around with the PostgreSQL databases while using the SQL Shell or psql however, the goal of this article was different from this. It aims to guide you on the connection mechanism of a PostgreSQL database while using the Windows 10 command prompt. By now, you would have realized the goal of this discussion. To ease their difficulty, we wanted to teach them the first step of using the PostgreSQL databases, i.e., connecting to the PostgreSQL databases. Therefore, most of the users also find using the PostgreSQL databases on Windows 10 quite challenging. However, we stated earlier that installing this RDBMS on a Windows 10 system is a little more complex than the Linux operating system. In our previous articles, we talked about the PostgreSQL server and the databases created with this server’s help.