Creating Tables

So what this app does when you click run is the SQL you write is sent off to a PostgreSQL database. The database then executes the SQL statement and creates a table.

Now you can imagine this is what it looks like in our database:

So we have one table inside of our database with the name of cities and that table has four columns and now we can start to add more tables, but there is a lot more going in with that query I used, but we can break that down in another wiki.