Hello all, I'm in the process of learning Postgres and I find it very hard to find a resource where postgres is explained in terms of developer. Since I'm in the process of reading and applying it in my side project; I treat this gist as my knowledge sharing place on Postgres and its features. Each sub-heading tries to explain the concepts of Postgres with simple example. I may be wrong at times here, if so please free to comment.
All the codes are written and run on psql
I would be adding many stuffs as I learn them. There is no particular order in which I add the contents.
I'm using the following postgres version:
SELECT version();