
Select the server of your choice and choose the default database postgres. Step 2: Next, you need to select a Postgres Server (click on the icon Select Postgres Server) in the side bar (at the bottom) of the Visual Studio Code user interface. Step 1: In Visual Studio Code, use the keyboard shortcut:Īnd select PostgreSQL: New Query (this will open a blank file). To be able to use your PostgreSQL database with Visual Studio Code, I recommend the PostgreSQL Management extension from Chris Kolkman.Īfter you have installed the extension and set up the database connection (see documentation), you can proceed as follows: You need to have PostgreSQL installed on your machine.In this tutorial, you will learn how to make SQL queries inside Visual Studio Code.
