I’ve been working with Postgresql now for a few months. It’s not as scary as I thought!
I wanted to post a couple of things I learned along the way in the hopes that it might help others looking for answers. One of the things that kind of bugs me about some message boards or help docs is that some of them don’t explain what the syntax means. If you’re new to sql, this can be a brain crusher because you’ll want to copy and paste into your editor but you will keep getting some type of error and won’t be able to figure out how to fix it. I hope to explain those things here to make it easier for anyone trying to learn or just stuck on a specific piece of syntax.
Feel free to leave comments or ask questions!