Connect With PostgreSQL using VS CODE for PRODUCTION

Key Takeaways

in the previous session we learned how to connect to postgresql using the command prompt or terminal today we will do the same thing but using vs code instead so without wasting any time let's get started to connect to postgresql you need to have vs code installed properly on your machine this applies to any operating system including Windows Linux or Mac I am assuming that you already have vs code installed if so please open it now because we will need to install some plugins here I have my vs code opened now that you have vs code open please go to the marketplace and search for the extension called SQL tools make sure to write SQL tools as a single word without any spaces here it is install it once you find it I will leave the link of this extension in the description after installing the extension you should be able to see it in the extension bar on the left hand side of your screen it will have an icon that looks like a database we are not done yet now we need to install drivers for postgresqls to do this go back to the marketplace and search for SQL tools postgresql both the SQL tools extension and the drivers are from the publisher Mathis Tech Zera however I will also leave the link to the driver in the description for your convenience anyways here is the driver the full name of the driver is SQL tools postgresql cockroach driver install it done once the driver is installed go back to SQL tools and click on add new connection then select postgresql this will open the connection assistant form which we will need to fill out we will be using the information from the installation string that we used in the installation video to do this okay let's start connection name you can name your connection whatever you want I will name my connection as postgres connection group leave it empty Connect using leave it set on server and Port server address since my postgres sequence is installed on the same machine thus I will leave it set on localhost in case you have installed your postgres sequence on a remote server then put the IP address of that server here Port if you remember while installing postgresql we exposed port number 5432 for the installation 5432 also happens to be the default port number for the postgresql we will use this same port number 5432 database here we have to put the name of the database to which we want to connect after installation of postgres equals we will be provided with a default database whose name is postgres this name is case sensitive so make sure to type it in all small letters username similar to database name with the installation we are provided with a default user again whose name is postgres all in small letters use password for the time being I will set this value to save as plain text in settings this is not recommended usually we set it to arcs to connect on doing so you will be asked to put the password every time you will connect with the database password here put the password of the database this is the same password you assigned while installation in my case it was postgres that's all we have to do leave the remaining Fields set on their default values now press test connection oops I got an error this is because my Docker container for postgres isn't running let me run the docker container here is my Docker desktop app and here is my postgres container let's run it done now let's test the connection once again successfully connected next press the save connection and then from the connection panel select the connection that you just created and right click on it and select connect in this worksheet you can write your SQL queries and run them let me show you how let's write a query to check the current username with which we are connected to run this statement press the run on active connection button and here is the result which is postgres that is how we connect with the postgres SQL server using vs code that's it for this tutorial hope you enjoyed watching it if so then give it a thumbs up also subscribe to the channel and press the Bell icon thanks for watching this is Manish from rebellionrider.com