Fetching records from the database

- [Instructor] Before starting to implement…the get all dishes function,…we need to do a couple of things with our Postgres database.…Open up Postico and go to nadiasgarden.…Inside the dishes.…You will notice that, by default,…the application, Postico, opens up your table…in the Content view.…We need the Structure view so we can add edit…the name of the columns.…

Go ahead and select the Structure tab.…And you will notice that now the Postico app…switches from the Content view to the Structure view.…And go ahead and change the name of the column…from imageURL camel case to imageurl all small case.…Postgres database doesn't really like…if you use camel casing or upper letters.…This will make our life much easier…when working with a Postgres database.…

Once you have done that, go ahead and also change the port…from 8080 to 8090, because 8080 port is a common port,…which can be used by Postgres database.…Once you have made those changes,…let's go ahead and create a connection to our database.…We will start by adding an instance called connection,…