How to Connect to PostgreSQL Database in Visual Sudio Code | PostgreSQL Queries in VS Code

let's see how we can connect to a postgres SQL database from Visual Studio code first open Visual Studio code go to your extensions or the shortcut is Ctrl shift and X type for postgres SQL host Square SQL and click on this post to SQL with 4.5 stars from Chris Buckman install this and after installing this on this left navigation bar you will see post create SQL Explorer click on this and click on this plus icon in the top now and type your host here I have postgresql installed installed in my localhost you can enter your server IP here so I'll just type localhost and what is the username of your post psql I'll write the super user that is post Grace and the password of the user that you just entered and the default Port is 5432 you can sell it to any port that postpaid server is listening on and I'll use standard connection for now and as you can see now the connection is made it is saying show all databases or show just this database and click on show all databases and yeah now it will show which name we want to show here you can write anything here I'll just write my local machine and as you can see now I'm connected to this my local machine poster server if I click on this I have access to this database right now no other databases now you can just see what is inside here all this stuff and you can write new query and all that stuff on this database if you have any questions let me know in the comments below

Channel: The Code City

Views: 4,794

Keywords:

Id: GJr3GFaQHoU

Length: 1min 54sec (114 seconds)

Published: Fri Jul 14 2023